Multiple tables - need 1 report

[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.

 

[Jeff Boyce]

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