queries (sql) in ACCESS help

[Guest]

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

 

[JulieD]

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.

 

[Guest]

Hi Sandra. This is an Excel discussion group. You might try the Access Group.

 

[Guest]

In the Access query designer select View>SQL 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

 

[Guest]

Thanks!