Access SQL

danielwajnberg · September 1st, 2003, 08:15 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.

Steven · September 26th, 2003, 05:58 PM

How many times can you ask this question without saying what's going wrong?
1) http://p2p.wrox.com/topic.asp?TOPIC_ID=3533
2) http://p2p.wrox.com/topic.asp?TOPIC_ID=3534
3) http://p2p.wrox.com/topic.asp?TOPIC_ID=3603
4) http://p2p.wrox.com/topic.asp?TOPIC_ID=3604
5) http://p2p.wrox.com/topic.asp?TOPIC_ID=3605

Seemingly 5.

I especially like 3604, where you say it doesn't give you the results you're looking for, but you don't say what results you're looking for or what results you get

I am a loud man with a very large hat. This means I am in charge