I'm having problems creating a InStr Function in a query to print out a report.
The user enters the StartDate (date format) for the Job Number Report but I would like the option of ALL, leaving the user with the choice of entering a date or leaving the prompt box blank.
The InStr Function in the query is:
Field: Expr1:InStry([Start], Blank = All, [FirstEntryT].[Start])
Criteria: >0 OR Is Null
This run but does not list the Startdate of the events in the report even though the StartDate is set to SHOW.
The user enters the StartDate (date format) for the Job Number Report but I would like the option of ALL, leaving the user with the choice of entering a date or leaving the prompt box blank.
The InStr Function in the query is:
Field: Expr1:InStry([Start], Blank = All, [FirstEntryT].[Start])
Criteria: >0 OR Is Null
This run but does not list the Startdate of the events in the report even though the StartDate is set to SHOW.