Access VBA help

danielwajnberg · September 1st, 2003, 08:16 AM

I have a question about SQL in access:
How come a simple query like:

SELECT creation_date FROM sapdadb_tunit group BY creation_date

will not work in Access, even though it works just fine on SQL Navigator?

Thanks.

Jeff Mason · September 1st, 2003, 08:28 AM

What do you mean when you say the query "...will not work in Access"?

I tried a similar query (since I don't have your database) on the sample Northwind database, e.g.

Code:

SELECT OrderDate FROM Orders GROUP BY OrderDate

and it gives me the result I would expect...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

danielwajnberg · September 1st, 2003, 08:38 AM

I can't explain it man. It just wonÂ´t give me the results I am looking for. I don't even get an understandable error message. Do you have any idea why that could be happening?

Jeff Mason · September 1st, 2003, 09:46 AM

What results are you looking for? What results do you get? What does the error message say? What is your table design? What does the data in it look like? Perhaps if you were a bit more specific, we could help - it's tough to diagnose your problem when we don't have any information to work with...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com