Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 1st, 2003, 08:20 AM
Authorized User
 
Join Date: Aug 2003
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.

 
Old September 1st, 2003, 10:05 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

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

 
Old September 2nd, 2003, 07:12 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

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
 
Old September 2nd, 2003, 10:40 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

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

 
Old September 2nd, 2003, 06:56 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
ADODB sql in Access VBA rjp Access 2 August 25th, 2004 07:27 PM
Which Book for VBA/Access/SQL/Excel? rmg VB Databases Basics 0 July 29th, 2004 03:19 PM
Access VBA - SQL question. Raelz Access VBA 4 February 10th, 2004 11:28 PM
Access 2002 VBA with SQL using a variable cpopham Access VBA 8 December 4th, 2003 04:24 PM
Date in Access VBA (SQL) Kenny Alligood Access VBA 2 September 14th, 2003 08:35 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.