Query

[David]

Hi,

I need some more help sorry if I am being a pest LOL.

In the database I am building, I have several tables that will contain
customers data, each table has differences but also has some fields that are
the same. I need to run a query showing fields from each of the different
tables.

If my question is not clear please let me know and I will try to explain
more

 

[John Spencer]

Open a new query
Select the 2 tables you want to see

Identify (in your mind) which fields in table one can be used to identify the
records in table two that match records in table one.

Drag from the matching field in table one to the matching field in table two
(Repeat if there are multiple sets of fields)

Add the fields to the grid that you want to see - double-clicking on a field
will put it into the grid (or drag the field to the grid) or select the table
and then the field using the comboboxes in the grid.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County