Question regarding queries

[Joshua Rack]

Hi Guys,

I need help with a question regarding queries?

I'm trying to do a quick test, and have been asked to create a query using
the wizard with a bunch of tables, and then create a "sigle query" that
selects the following records: orders with more than 3 packs ordered, orders
with the pack price higher than $10 and orders are sorted in ascending
surname order

These obviously being entries in the table.

I'm lost to how to do this?

Anyone able to help?

Thanks in advance,
Josh

 

[dhstein]

You could go to Query Design - instead of Query Wizard - In My Opinion it is
easier. The "Show Table" box pops up. Select each table that you need in
your query and click "Add Table" (BTW I have Access 2007 - so I'm not sure
if your screens are the same). After you've selected all the tables you
need, click "Close" to close the table selections. Now at the bottom of the
screen you have your field selections. Go to the first column and in the
second row - select one of your tables and in the first row select one of
your fields. At this point you can click the "Run" (Red exclamation point)
to see what happens. Then go back to "Design view" and continue entering any
fields you want in your query. There is a "Criteria" row in which you could
enter "> 10" for example for the price field. It's pretty intuitive - just
play with it a little bit.