look up querie null or between

Magna

New Member
Joined
Mar 11, 2014
Messages
47
Hello all and thanks for looking what have is a queries that does a look up between to cells with dates and that works great but I would like it to look up the dates if there if the cells are null then I want it to look up all records in the table Between [Forms]![Work Order]![Text99] And [Forms]![Work Order]![Text101] this is my between statement thank you for any and all help
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,690
Office Version
  1. 2013
Platform
  1. Windows
This is confusing. Can you describe this better? Perhaps give sample data and hoped for results, as well as any query or function you have tried so far.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,026
Messages
5,526,325
Members
409,696
Latest member
EERS

This Week's Hot Topics

Top