Filtered Query

[hceonetman]

This is probably simple: I have a table of employee absences with a field 'absencedate'. There is also a table of annual pay periods with fields for period number and begin and end dates. I want a query to filter out absence records from previous years by using the criteria 'absence.absencedate >= payperiods.paystartdate. However, since there is no relationship between the two tables, my query comes up empty. I want it to be based on the paystartdate in the first record in the payperiods table.

Thanks for the help.
HCEONETMAN

 

[hceonetman]

Oops. Actually the query works, I didn't have good data to test with. Apparently when there is no relationship defined between the two, the first record in the table is used. I hope nobody wasted too much time trying to answer this one.
HCEONETMAN


I guess that's what they call 'having a blonde moment'.