I have been asked to learn Access for work. I have never done any programming and have three "Dummies" books. But, I am so confused.
My boss has been giving me challenges. I think I understand most of what I am supposed to be doing, but I can not figure this one out.
I have been asked to write a report showing some customers that live in CA and to sort them by order numbers. I was told to do this with code using the "DoCmd.RunSQL" command. So I tried this:
Dim mSQL As String

mSQL = "SELECT Name, State, Orders _
FROM Customers _
WHERE state = "CA" _
ORDER BY Orders _

DoCmd.RunSQL mSQL

Then I found out the I cannot use the SELECT command, because it doesn't return a value. So, how would I write the coding to open a form with just the above information using the "DoCmd.RunSQL" command? Or am I supposed to be using a Recordset instead? Any help I can get would be very helpful.

I am not an ACCESS/VBA guy and you might want to move this to an Access forum but this post might help you:

http://www.databasejournal.com/featu...le.php/3505836

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========

Thank you for your help. I am sorry I was in the wrong place. Thanks again for your help.

Hi Misty

This seems like a really simple query to run in Access just using the SQL, rather than using the VBA to run the SQL.

Create the query in the Design View - Close all the tables and then click on the Design View button - it should drop down to SQL (if that isn't default) Then type in your query:-

SELECT Name, State, Orders
FROM Customers
WHERE state = "CA"
ORDER BY Orders {ASC |DESC};

ASC for ascending DESC for descending. Save it and name it. Either click on the red bang ! or run it from your query menu.

The Dummies book about Access isn't the best. If you like SQL, Bagui and Earl have a nice little book called "Learning SQL through Access". Equally, Gavin Powell's "Beginning Database Design" does exactly what it says on the label. Check out the Utter Access forum.