Query Showing No Activity By Date Range

[GWBMan]

I have this query that pulls in all data that have no activity. However, I want to pull data that have no activity for a specified date range. Help please!



This gives me all records with no activity:

SELECT tblDriver.FirstName, tblDriver.LastName, tblReceiptHistory.ReceiptNumber
From tblDriver LEFT JOIN tblReceiptHistory
ON tblDriver.DriversLicense = tblReceiptHistory.DriversLicense
WHERE tblReceiptHistory.DriversLicense Is Null;

I would like to pull Null records from tblReceiptHistory for a specified date range.

I tried this but it returned no data:


SELECT tblDriver.FirstName, tblDriver.LastName, tblReceiptHistory.ReceiptNumber, tblReceiptHistory.ReceiptDate
FROM tblDriver LEFT JOIN tblReceiptHistory ON tblDriver.DriversLicense = tblReceiptHistory.DriversLicense
WHERE (((tblReceiptHistory.ReceiptDate) Between [ENTER 1st DATE] And [ENTER 2nd DATE]) AND;((tblReceiptHistory.DriversLicense) Is Null))

[June7]

Move the ; after AND to end of query. Did the query really save with that?

[GWBMan]

Sorry, typo. This what I actually have that returns no record:

SELECT tblDriver.FirstName, tblDriver.LastName, tblReceiptHistory.ReceiptNumber, tblReceiptHistory.ReceiptDate
FROM tblDriver LEFT JOIN tblReceiptHistory ON tblDriver.DriversLicense = tblReceiptHistory.DriversLicense
WHERE (((tblReceiptHistory.DriversLicense) Is Null) AND ((tblReceiptHistory.ReceiptDate) Between [ENTER 1st DATE] And [ENTER 2nd DATE]));

[recyan]

Check if below works :

Between DateValue([ENTER 1st DATE]) And DateValue([ENTER 2nd DATE])

Thanks

[GWBMan]

That still pulled no records

This is what I have now:

SELECT tblDriver.FirstName, tblDriver.LastName, tblReceiptHistory.ReceiptNumber, tblReceiptHistory.ReceiptDate
FROM tblDriver LEFT JOIN tblReceiptHistory ON tblDriver.DriversLicense = tblReceiptHistory.DriversLicense
WHERE (((tblReceiptHistory.DriversLicense) Is Null) AND ((tblReceiptHistory.ReceiptDate) Between DateValue([ENTER 1st DATE]) And DateValue([ENTER 2nd DATE])));

[June7]

Don't see anything wrong with the syntax so problem must be with data. Would have to review. If you want to provide db, follow instructions at bottom of my post.