Run query on different tables

G

Guest

n00b question here.

I've got a simple dbase of material lists for differnet client projects.
The tables are individual projects material lists comprised of an individual
record for each individual timber piece. I've got a simple totals query that
returns a nice compiled, subtotaled list of material for an existing table
called tblMaterial. I'd like to apply that query to any one of the project
tables like tblCarter_Timber or tblJohnson_Timber.

Can anyone point me in the right direction?
 
S

Steve Schapel

Kurt,

Without knowing enough details to really know... I would suspect that
you shouldn't have "project tables like tblCarter_Timber or
tblJohnson_Timber." Whatever data is in these tables would probably be
better all in one table, with an additional field to identify the
project that each record is related to. It is likely that the type of
query you are talking about would then become much simpler.
 

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

Similar Threads

Specific and general Access questions. 3
Beginners question: Hyperlinks into tables in a word document 2
Obtaining data from a table in a query using the Dlookup function 2
Add Invoice Autonumber to Report, Break Out Clients 6
complicated query --join 2
Running a query on a table based on a form. 5
Columns with different row sources 1
Why base Forms on Queries and not Tables? 4

Top