Using multiple tables in a query

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

Guest

I'm using two tables for 1 query. I have 'Main' and 'POs'. The query is based
mainly on the fields in POs. I am using 1 field from 'Main' which is weight.
This field serves as a running sum of the weight on all the POs.

PO field in 'POs' and PO field in 'Main' share a 1 to many relationship.

Only problem is, if there are no records for the PO in 'Main', the query
won't display the PO from 'POs'. The sort for PO from 'POs' is set to first,
the sort for Weight from 'Main' is set to sum.

I am using this for my date criteria:
=DateSerial(Year(Date()),Month(Date()),1) And <=DateSerial(Year(Date()),Month(Date())+1,0)
Click to expand...

How do I show all PO's for the month whether there are any records or not
from Main?

Thanks
 
hi,
i would guess that you have a join problem. i think you
will need to have a right join instead of a inner join.
read up on joins in help.
hope this helps
 
Back
Top