LastUpdated-field.png' alt='Microsoft Access Query Select Last Record' title='Microsoft Access Query Select Last Record' />Hi I just created what I thought was a simple query. I want it to take data from another query, and update the corresponding fields based on primary keys in a table. However, when I try to run it, I get an error operation must use an updateable query. Does anyone know why this might be Heres my SQL, in case you need it. UPDATE Sales. Rep. Monthly. Open. Orders. Aggregate. Q INNER JOIN Sales. Professional forum and technical support for computerIT pros for Microsoft Access Modules VBA Coding. Includes problem solving collaboration tools. DisplayAll.gif' alt='Microsoft Access Query Select Last Record' title='Microsoft Access Query Select Last Record' />Rep. Monthly. T ON Sales. Rep. Monthly. Open. Orders. Aggregate. Error Accessing Registry Windows 7 Important. Q. Salesperson Sales. Rep. Monthly. T. Salesperson AND Sales. Rep. Monthly. Open. Orders. Aggregate. Q. Month Sales. Rep. Monthly. T. Month AND Sales. Rep. Monthly. Open. Orders. Aggregate. Q. Year Sales. Rep. Access 2003. Access 20. Select Orders in the Database window. Choose Query from the New Object button on the Standard toolbar. Click Design View in the New. Queries help retrieve information from your database. Heres how to create a simple select query. Crosstab query tips for Microsoft Access. Provided by Allen Browne Created August 2006 Last updated April 2010. How to Use Microsoft Access. Microsoft Access is a database creation program that allows for anyone to easily maintain and edit a database. It is suitable. Monthly. T. Year SET Sales. Rep. Monthly. T. Open. Order. Price sumofprice Select all. Open in new window. Back to Free MS Office Tutorials Press CtrlF to search for a word. Microsoft Access Glossary.