| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to write parameter query with "or is null" criteria
Excel Office 2003
I am trying to use multiple parameters where the user can leave any given parameter blank and it will return the record-set. When I attempt to use a Or "Like [Enter Year:] is null" and run the query, it returns a syntax error message. I appreciate any help you can give. Thanks, - Vince |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
| Criteria using "Or" and parameter query | Excel Discussion (Misc queries) | |||
| Parameter Query in MS Query | Excel Discussion (Misc queries) | |||
| How do i enable the Query Parameter menu option on the External D. | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
