Hi,

Is there anyway to add criteria to a query so when a report is run it prompts you for:

Show all records entered today or hit enter for all records?

Thanks.

I use this for filtering other data but I cannot seem to make it work with a date..

Like "*" & [Enter Part of The OFFICE or Enter For All Records] & "*"

Thanks.

Fen How

Dates are specific. They are stored as longs in the database. When you convert them to strings you can use your "Like" statement.