If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
queries (sql) in ACCESS help
I usually work with FoxPro using SQL.
Now I have to use Access to make some queries. Could any of you tell me if I need to install some libraries to use group by, etc. What do I need to do to create my query and execute it? From where? Thanks, Sandra |
#2
|
|||
|
|||
Hi Sandra
if you're using Access, go to the queries object section and create your query in there ... you don't need to install anything for most queries. - basically you click on the NEW button, choose Create query in design view, choose the tables you want to use, then double click on the fields from these tables that you want in the answer and then click the red exclaimation mark to run the query. To "group" by use the E icon on the toolbar. Additionally, a better newsgroup for you is probably microsoft.public.access.queries if you're using Excel somewhere in this, then if you'ld like to let us know how you want Excel & Access queries to work together, we might be able to assist more. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Sandra Aguilar" wrote in message news I usually work with FoxPro using SQL. Now I have to use Access to make some queries. Could any of you tell me if I need to install some libraries to use group by, etc. What do I need to do to create my query and execute it? From where? Thanks, Sandra |
#3
|
|||
|
|||
Hi Sandra. This is an Excel discussion group. You might try the Access Group.
-- Sincerely, Michael Colvin "Sandra Aguilar" wrote: I usually work with FoxPro using SQL. Now I have to use Access to make some queries. Could any of you tell me if I need to install some libraries to use group by, etc. What do I need to do to create my query and execute it? From where? Thanks, Sandra |
#4
|
|||
|
|||
In the Access query designer select ViewSQL View from the menu, then you can
type *most* SQL commands there. Access doesn't handle SQL subqueries very well. You're often better off creating & saving the subquery as a standalone query, then refernecing that in the outer query "Sandra Aguilar" wrote: I usually work with FoxPro using SQL. Now I have to use Access to make some queries. Could any of you tell me if I need to install some libraries to use group by, etc. What do I need to do to create my query and execute it? From where? Thanks, Sandra |
#5
|
|||
|
|||
Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why is a French Spellchecker a "required" update for English speak | French Spellcheck Required? | General Discussion | 23 | April 26th, 2005 01:17 AM |
Create a sum of records in an open recordset(Access97) | Reiner Harmgardt | General Discussion | 0 | March 7th, 2005 10:03 AM |
Faster SQL / Access queries? | Bret | Running & Setting Up Queries | 2 | January 20th, 2005 09:45 AM |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |
Function isn't available in expressions in query expression | Reiner Harmgardt | General Discussion | 4 | July 21st, 2004 09:30 AM |