Here is the SQL...Thanks!

SELECT CallLog.CallID, Subset.LASTNAME, Subset.FIRSTNAME,
CallLog.CallType, CallLog.ShortDesc, CallLog.RecvdBy,
CallLog.RecvdDate, CallLog.RecvdTime, CallLog.ModBy,
CallLog.ModDate, CallLog.ModTime, CallLog.Tracker
FROM heatdb.dbo.CallLog CallLog, heatdb.dbo.Subset Subset
WHERE Subset.CallID = CallLog.CallID AND
((CallLog.Tracker='HaggardB') AND (CallLog.RecvdDate=?))
ORDER BY CallLog.Tracker, CallLog.RecvdDate,
CallLog.ModDate


-----Original Message-----
What is the SQL statement you are using?

P


"Bill" wrote in message
...
I have a spreadsheet that has an MS Query embedded in
it.
The query pulls from a database and then returns the
data
to the excel spreadsheet. I have a field that I'm
prompted for called Received Date. Right now, when I
open
the spreadsheet I get a dialog prompting me for the
date.
What I want to do is change this to automatically use
the
current date.

I right click on the data in the spreadsheet and select
edit query. Here is where I need help. I can't seem to
pinpoint the syntax to use today's date. I've tried
=Today()
=Date

and so on. Can any one tell me how to do this?
Thanks
Bill


.