- Joined
- Aug 31, 2012
- Messages
- 4
- Reaction score
- 0
I don't really know the best way to word this but:
I'm trying to join two tables in a query. Table 1 has AssociateID and VTDate, Table 2 as AssociateID and NSDate.
What can happen is, an associate could have a Tally (Table1) for a date, but possible to not have a NS entry (Table2), that's easy to join/relate. But at the same time, an associate can have an NS Entry (Table2) but not have a Tally (Table 1) to relate to.
I want to be able to pull up ALL of Table #1 Records even if Joined/Related Fields from Table #2 doesn't exist AND pull up ALL Records from Table #2 even if Joined/Related Fields from Table #1 doesn't exist and have both records in ONE query.
Is this possible?
I'm trying to join two tables in a query. Table 1 has AssociateID and VTDate, Table 2 as AssociateID and NSDate.
What can happen is, an associate could have a Tally (Table1) for a date, but possible to not have a NS entry (Table2), that's easy to join/relate. But at the same time, an associate can have an NS Entry (Table2) but not have a Tally (Table 1) to relate to.
I want to be able to pull up ALL of Table #1 Records even if Joined/Related Fields from Table #2 doesn't exist AND pull up ALL Records from Table #2 even if Joined/Related Fields from Table #1 doesn't exist and have both records in ONE query.
Is this possible?