Using multiple tables in a query

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

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

Thanks

 

[Guest]

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