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

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

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

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

Thanks!