Populate null value with the parameter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to populate null query results with the parameter the user
typed?

Because of how my queries are set up the user types in a date, for example,
11/04, but not all of the Date fields are populated with 11/04 and I need
them to be.

Any ideas?

Thanks
 
First, 11/04 is not a date. A date has to have A year, a month, and a day.

Second, whereever you need to use the value of the parameter you can use an
expression similar to the following.

Nz([SemiDateField],[Parameter prompt])

that should replace SemiDateField values of Null with whatever is entered for
the [Parameter Prompt]
 
Back
Top