Subqueries


D

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!!
 
Ad

Advertisements

Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top