ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How to write parameter query with "or is null" criteria (https://www.excelbanter.com/new-users-excel/82238-how-write-parameter-query-null-criteria.html)

Vincent Alliance

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


All times are GMT +1. The time now is 06:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com