Date Query using VB in Access XP

[mickey_lin_uk]

Date Query in Access XP

Hi,

I am trying to run a query that when you click on it, it shows any due dates for inspections test to appear for the month your in. E.g. I want to know all the inspections tests that are due in June. I have the following code but it doesn’t seem to work, it will show some of the tests due but not all of them.

Here’s the SQL:



SELECT [tblemployee Details].Department, [tblemployee Details].[Payroll No], [tblemployee Details].[First Name], [tblemployee Details].ADateDue, [tblemployee Details].LDateDue, [tblemployee Details].CDateDue, [tblemployee Details].CCDateDue, [tblemployee Details].SDateDue, [tblemployee Details].HDateDue, [tblemployee Details].MDateDue, [tblemployee Details].RDateDue
FROM [tblemployee Details]
WHERE (((Month([tblemployee Details].[LDate Due]))=Month(Now()))) OR (((Month([tblemployee Details].[LDate Due])=Month(Now()))=True))
ORDER BY [tblemployee Details].Department;

Thanks

Michelle

 

[Mile-O]

• ADateDue
• LDateDue
• CDateDue
• CCDateDue
• SDateDue
• HDateDue
• MDateDue
• RDateDue

What are these supposed to represent and why are they in the employee details table?