Id number not found

[Nick]

I am having trouble with this query, it does not show any data if the
Employee_id does not match what I have on file. I woudl like the query to
show the data and tell me "NO match of employee Id found" Is that possible?
SELECT DISTINCTROW ALID0001.scans, ScannAction.Scanname, ALID0001.scans,
ALID0001.label_id, ALID0001.date, ALID0001.time, ALID0001.Delete,
ALID0001.route_id, ALID0001.Employee_id, ALID0001.Scanner_id, [Last Name] & "
," & [first name] AS Expr1, AccountAction.AccountAction

FROM AccountAction INNER JOIN (ScannAction INNER JOIN (Employees INNER JOIN
ALID0001 ON Employees.ScannerId = ALID0001.Employee_id) ON
ScannAction.ScanActionId = ALID0001.scans) ON AccountAction.AccoutnNo =
ALID0001.Manual
WHERE (((ALID0001.scans) In (SELECT [scans] FROM [ALID0001] As Tmp GROUP BY
[scans],[label_id] HAVING Count(*)>1 And [label_id] = [ALID0001].[label_id])
And (ALID0001.scans)="01") AND ((ALID0001.date) Between [enter date] And [end
date]) AND (("01")<>"19"))
ORDER BY ALID0001.scans, ALID0001.date DESC;

 

[Duane Hookom]

Use the query as the record source of a form or report. You can use the On
No Data event to pop up a message box to the user.