Need Help with MS Query and EXCEL

[rgildoss]

Ok , this may sound weird but here goes.

I’m doing a Database query ( in EXCEL through MS Query ), the query requires dates such as,

Created Date: >=#8/1/2002 12:00:01 AM# And <=#8/31/2002 11:59:59 PM#

The above string gives me everything recorded ( in the database ) between the dates 8/1/02 and 8/31/02

My question:

Is there away to created a field in the Excel spreadsheet that I can input the date I want to search without going into the MS Query and changing the date?

This is really bugging me. Every time I run the query I have to go in and change the dates, it would be nice if I could just input the date into a box or a field and have the ms query do search on that date.


PLEASE HELP!!!!

 

[dk]

Hi,

This thread may be of some use. If not, post the SQL of your query. The jist of it is, you can use cell references if you use VBA, or you can have an inputbox displayed which can ask you for the dates you want.



_________________<font face="Impact">Hope this helps,
Dan</font>
This message was edited by dk on 2002-10-14 13:05

 

[rgildoss]

Ok , i did try some of the sug that people made on the other thread, however i still get a error when i try to send data back to the excel sheet, i get a pop up with
"Parameter Missing"

Im also using office XP
( not sure if that does anything )

Below is the past of SQL:

SELECT "RPMS Problem Report"."Customer Name", "RPMS Problem Report"."1_Entry-Id", "RPMS Problem Report"."3_Create-date", "RPMS Problem Report"."8_Short-Description", "RPMS Problem Report"."7_Status", "RPMS Problem Report".Severity
FROM "RPMS Problem Report" "RPMS Problem Report"
WHERE ("RPMS Problem Report"."3_Create-date">={ts '2002-03-10 00:00:01.000'} And "RPMS Problem Report"."3_Create-date"<={ts '2002-03-16 23:59:59.000'}) AND ("RPMS Problem Report"."CBG LOB"='Staff Legal')

 

[Mark W.]

See the Excel Help topic for "Create a query that prompts for criteria".