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
...
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