Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Passing Dates criteria in MS Query
You are correct with the square brackets but you need to add the prompt text
between the brackets [Start Date] and [End Date] -- HTH... Jim Thomlinson "RW" wrote: I am trying to use MS Query to briong back data from DB2 tables. I have the query set up in the design view. I have several sets of criteria. Field1 = '1' Field2 = 'Y' Test Date Between #2/1/08# and #2/29/08 The query runs and returns the correct data. However, I need the dates to equal 2 cells on a worksheet. I have tried using Between [ ] and [ ] as well as Between #[ ]# and #[ ]# but neither works. The sql shows the date criteria as Between {d '2008-02-01'} and {d '2008-02-29'} I have even tried to replace the '2008-02-01' and '2008-02-29' with [ ] and also with ? without success. What is the proper syntax to initiate the prompts so that I can set the parameters on cells on an excel spreadsheet? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing Query String into MS Excel | Excel Discussion (Misc queries) | |||
passing dates in a conditional sum(if) | New Users to Excel | |||
db query with dynamic criteria | Excel Discussion (Misc queries) | |||
query criteria question | Excel Discussion (Misc queries) | |||
Microsoft query criteria help | Excel Discussion (Misc queries) |