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 _
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.