hokiewalrus
Registered User.
- Local time
- Today, 06:57
- Joined
- Jan 19, 2009
- Messages
- 50
I have a query that if run alone, returns the records I would expect.
However, when I bind a form to that query, I get no records returned no matter what I do. Is there any reason this would happen? My other forms bound to different queries work as expected.
The query (the hardcoded date is for testing only):
I've also attached a screenshot of the properties of the form, if that is worth anything.
I'm sure I'm missing something easy here, but I'm at a loss.
However, when I bind a form to that query, I get no records returned no matter what I do. Is there any reason this would happen? My other forms bound to different queries work as expected.
The query (the hardcoded date is for testing only):
Code:
SELECT TableEmployee.PayrollNumber, TableEmployee.LastName, QueryCollectedPayrollWeek.PayrollStatus, QueryCollectedPayrollWeek.WeekEndDate
FROM TableEmployee LEFT JOIN QueryCollectedPayrollWeek ON TableEmployee.PayrollNumber = QueryCollectedPayrollWeek.PayrollNumber
WHERE (((QueryCollectedPayrollWeek.WeekEndDate)=#1/13/2010#))
ORDER BY TableEmployee.PayrollNumber;
I've also attached a screenshot of the properties of the form, if that is worth anything.
I'm sure I'm missing something easy here, but I'm at a loss.