date parameter queries with wild card

[lwarren]

I know I've got something wrong here: Between "*" & [Start Date? (MM/DD/YY)] & "*" And "*" & [End Date?(MM/DD/YY)] & "*"

[pbaldy]

I don't think wildcards work well with dates. Are you looking to cover them leaving a parameter blank? Try this type of thing:

Between Nz([Start Date? (MM/DD/YY)] , #1/1/1900#) And Nz([End Date?(MM/DD/YY)] , #12/31/2029#)

[lwarren]

I was trying to do two things either choose parameters for a specific time from to/from date or show all if no parameter is entered. What you provided works. Thanks.

[pbaldy]

No problem, and welcome to the site!