View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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