K
Kathy
Hello...I am using a parameter query to check if patients received or did not
receive an injection during the rate range (Start-End Date) specified. The
following code (see below) is working successfully for patients who did
receive an injection during the date range. But I would like to also find
patients who did not receive an injection and therefore have no dates in the
specified date range...sort of the inverse of the first part. Any help is
greatly appreciated...I hope this is easy, but I am stumped. Thank you.
Between Nz([Forms]![frmParameter]![txtStartDate],#1/1/1900#) And
Nz([Forms]![frmParameter]![txtEndDate],Date())
receive an injection during the rate range (Start-End Date) specified. The
following code (see below) is working successfully for patients who did
receive an injection during the date range. But I would like to also find
patients who did not receive an injection and therefore have no dates in the
specified date range...sort of the inverse of the first part. Any help is
greatly appreciated...I hope this is easy, but I am stumped. Thank you.
Between Nz([Forms]![frmParameter]![txtStartDate],#1/1/1900#) And
Nz([Forms]![frmParameter]![txtEndDate],Date())