Question on MS Query in Excel
 

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

Question on MS Query in Excel
 

I've used

=Now()

successfully in the past to set today's date...have you
tried that

Michael Bond

-----Original 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
.

Question on MS Query in Excel
 

I just did tried it and get the error: 'Now' is not a
recoginzed function name. Satement(s) can not be
prepared. Same thing with Today and Date.

Thanks!
Bill


-----Original Message-----
I've used

=Now()

successfully in the past to set today's date...have you
tried that

Michael Bond

-----Original 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
.

.

Question on MS Query in Excel
 

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

Question on MS Query in Excel
 

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


.