SQL query

[AndyShuter]

Would someone be kind enough to help me out with this one??

I'd like to show records between these dates and anything that contains a blank date

>=[Forms]![listbox2]![Text15] And <=[Forms]![listbox2]![Text17]

I have a similar operation that goes like this....

Like "*" & [Forms]![listbox2]![Combo442] & "*"

.. but don't know how to make the top one work


Many Thanks

 

[dgm]

By sql query u mean in a WHERE statement?

for example:

SELECT * FROM myTable
WHERE ((myTable.myDate BETWEEN [Forms]![listbox2]![Text15]
AND [Forms]![listbox2]![Text17])
OR (myTable.myDate IS NULL))

 

[AndyShuter]

No Sorry....

The command sits in the criteria box in a query

 

[dgm]

Same sort of thing then...

in the first line of the date criteria put:
BETWEEN [Forms]![listbox2]![Text15] AND [Forms]![listbox2]![Text17]
And in the second line put:
IS NULL

 

[AndyShuter]

Thanks - works great!

w