Joining Tables/Queries

M

Maxwell

Help.

Trying to create a form that will join two separate tables into 1 form.

1 table has sales units sold for the year 2004 by weeks. The second table
has inventory units for 2004 by weeks.

I want the form to pull both tables and show what apples sold and what
inventory it had. Has to be related by item...

Hope that was clear as mud
 
O

Ofer

You need to create a query that join the two tables, with the unit and week
fields

SELECT sales.units , sales.week, sales.[units sold], inventory.[units]
FROM inventory INNER JOIN sales ON (inventory.units = sales.units ) AND
(inventory.week= sales.week)

HTH
 
Top