Hi,
Typo. Guage (goo-age) is not Gauge (go-ge).
Probably late in the day (or early in the morning... :-) )
Hoping it may help,
Vanderghast, Access MVP
"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;