Help with Query

[zyberjock]

I am trying to execute this code but I get an error that says that I tried to execute a query that does not include a specified expression., Can anybody help me out on this one.

SELECT Min(EvnLog.[TimeDate]) as EntryDate, EvnLog.LName, EvnLog.FName, EvnLog.Event
FROM EvnLog
WHERE (((EvnLog.Event)=8) AND ((EvnLog.[TimeDate])>=#4/1/2009#));

Thanks.

[tinytree]

SELECT EvnLog.[TimeDate] as EntryDate, EvnLog.LName, EvnLog.FName, EvnLog.Event
FROM EvnLog
WHERE envlog.[timedate]=(select min(b.timedate) from evnlog as b where((EvnLog.Event)=8) AND ((EvnLog.[TimeDate])>=#4/1/2009#)));

[tinytree]

SELECT EvnLog.[TimeDate] as EntryDate, EvnLog.LName, EvnLog.FName, EvnLog.Event
FROM EvnLog
WHERE envlog.[timedate]=(select min(b.timedate) from evnlog as b where((b.Event)=8) AND ((b.[TimeDate])>=#4/1/2009#)));