p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Access SQL/VBA help (http://p2p.wrox.com/showthread.php?t=3387)

danielwajnberg September 1st, 2003 08:20 AM

Access SQL/VBA help
 
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.


Bob Bedell September 1st, 2003 10:05 AM

Hi Dan,

Please post one question to one forum to prevent the discussion from getting scattered across multiple forums. See Jeff Mason's reply to your post on the Access_VBA forum.

Regards,

Bob


SerranoG September 2nd, 2003 07:12 AM

Quote:

quote:Originally posted by Bob Bedell
Please post one question to one forum to prevent the discussion from getting scattered across multiple forums. See Jeff Mason's reply to your post on the Access_VBA forum.
Bob, why are there multiple Access VBA forums scattered about? Shouldn't there be just one?


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Bob Bedell September 2nd, 2003 10:40 AM

Quote:

quote:Bob, why are there multiple Access VBA forums scattered about? Shouldn't there be just one?
Hi Greg,

Good question. Beats me, though I would say that Acces's hybrid nature is given to spawning confusion and overlap like that. Technically speaking, Access isn't a database either. Its just a GUI development platform that defaults to Jet as its data store. So do we put it with the database forums? Or create a Jet SQL forum? Then where does Acces go? As a COM component, it only hosts the VBA language engine. So maybe an ActiveX forum and a VBA forum? Then again, when programming in VB, VBA, or VB.Net, we're just using platform-specific versions of BASIC. A BASIC forum, a Jet SQL forum, and an ActiveX components forum? Ya' gotta stop somewhere.

I imagine the WROX guys probably had several conversations along these lines (ok...probably not), got tired of thinking about it, and said the heck with it. Would have been convenient, though, if they had arbitrarily opted for one spot or the other.

Bob


Bob Bedell September 2nd, 2003 06:56 PM

Hi Greg,

I thought I'd have another crack at responding to your post in a way that actually makes a little sense. I just posted to the Feedback forum asking if it might be possible to consolidate the Access_VBA forums into a single forum. We'll see what the management's thoughts are on the matter. It would be nice if they could be brought together.

Regards,

Bob



All times are GMT -4. The time now is 11:25 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.