Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
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.

Reply With Quote
  #2 (permalink)  
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

Reply With Quote
  #3 (permalink)  
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
Reply With Quote
  #4 (permalink)  
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

Reply With Quote
  #5 (permalink)  
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

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 07:52 PM.


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