Subqueries

[Deb]

I have one query that pulls records from a table and sums the quantities from
several fields (transaction quantities). It is an inventory table with
multiple items using the same part number (driven by a part number lookup
table).

I need to build forms and reports that will show the items grouped by part
number and then by unit cost (same part number may cost different amounts).
I built a second query that just groups the part number and unit costs.

The forms and reports need to be built on the two queries (unless there is
an easier way), and I'm assuming that the second of the two queries might be
considered a "subquery", but I'm having a hard time finding information
specifically on "subqueries" and linking the two together to get the
appropriate results.

DESPERATE!!

 

[Gina Whipp]

Deb,

I am assuming you just want information on subqueries...

http://allenbrowne.com/subquery-01.html

http://allenbrowne.com/subquery-02.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Deb]

Hi Gina:

You seem to be coming to my rescue regularly now.

Perhaps I should explore http://allenbrowne - is it primarily about Access
2003?

 

[Gina Whipp]

Deb,

Hold on... I 'm looking for my cape (Just Kidding)! Glad to be of help...

Yes Allen Browne's site is mostly about Access 2003 there is alot of
information about Access 2007. And as long as you are exploring that site,
here a few more...

http://www.granite.ab.ca/accsmstr.htm

http://www.mvps.org/access/

http://www.rogersaccesslibrary.com/OtherLibraries.asp

http://www.databasedev.co.uk/

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm