Joining Tables/Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top