Multiple tables - need 1 report

  • Thread starter Thread starter BarbaraB
  • Start date Start date
B

BarbaraB

5 tables, each with vendor names, locations, trade and bid amount for a
specific project (construction).
I need one report showing all the bids from one vendor, i.e. plumber with
the name of each project, his bid amounts and a few other items.

I do not know how to get this info from each table and consolidate it into
one report.
 
Barbara

Keeping separate Access tables for each project is just the design you'd use
.... if you were limited to a spreadsheet!

If you want to get easy use of Access' relationally-oriented
features/functions, you can't feed it 'sheet data.

Spend a little time reading up on "normalization" and "relational" before
you undertake the reporting. While there is probably a way to do it from
your starting point, you will only make more work for Access and yourself in
the long run.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top