Date as a Parameter in MSQuery(SOLVED)

[lenze]

I want to query an oracle database and would like to use a parameter to return all records with an overdue inspection date (ie, Due Date is less than Today(). It need to be volatile as others need to run the query on a weekly basis. I can't seem to get it to function using either a prompt or a cell reference.
TIA
This message was edited by lenze on 2002-09-16 06:58

 

[9tanstaafl9]

I will try that right now, thank you.

 

[ToyMiller]

I have a sheet with an MSQuery in it that uses something similar to what you seem to want. I have two parameter fields created in my msquery called [From] and [To]
In the criteria box in msquery the field i typed >=[From] (referring to "fr_date" in my sql table - likewise, the other parameter id <=[To]
Both refer to cells in my XL workbook which could return the value of a formula such as =today()
And I just tested it and it works fine...
Don't think there's any need for a more complex approach really....

I am using a much newer version on excel and having problems creating parameters in excel using a SQL query.

Any help would be appreciated.

-T