Thread: How to write parameter query with "or is null" criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Vincent Alliance
 
Posts: n/a
Default 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 With QuoteReply With Quote