Dear D:
You have misspelled "Gauge" as "Guage"
That should do it!
Tom Ellison
"D Witherspoon" wrote in message
...
Whenever I try and run this query a pop-up box comes up asking for the
value of tblWorkLog_Main.GuageID.
Why is this happening. According to the following 2 articles my query
should work. I've never had this problem in SQL Server.
http://www.tek-tips.com/faqs.cfm?fid=4058
http://support.microsoft.com/?kbid=209066
Both queries work fine independantly (as long as I remove the reference to
tblWorkLog_Main in the sub query if I run it by itself).
I'm using MS Access 2000.
SELECT WorkLogID, GaugeID, NextCertDue,
(SELECT TOP 1 NextCertDue
FROM tblWorkLog wl
WHERE GaugeID =tblWorkLog_Main.GuageID
AND
WorkLogID 1
ORDER BY NextCertDue Desc) AS DueDate
FROM tblWorkLog tblWorkLog_Main
ORDER BY GaugeID, NextCertDue DESC;