Prompt for criteria in report

[jhicsupt]

I have a report that I would like to prompt for criteria to determine whether
or not a checkbox gets checked.

I want to prompt the user for date of meeting.

Checkbox = includeckbox

If [DateofMeeting]=#6/18/2007#, then I want a check in [includeckbox],
otherwise do not put a check. The report is run off of a query, so if I put
=#6/18/2007# in the query criteria, it only limits the records to those
records that have #6/18/2007# in [DateofMeeting].

For those records that have dateofmeeting as 6/18/2007, the includeckbox
would be checked. For those records that do not have dateofmeeting as
6/18/2007, the includeckbox would not be checked.

Thanks in advance.

 

[Carl Rapson]

I have a report that I would like to prompt for criteria to determine
whether
or not a checkbox gets checked.

I want to prompt the user for date of meeting.

Checkbox = includeckbox

If [DateofMeeting]=#6/18/2007#, then I want a check in [includeckbox],
otherwise do not put a check. The report is run off of a query, so if I
put
=#6/18/2007# in the query criteria, it only limits the records to those
records that have #6/18/2007# in [DateofMeeting].

For those records that have dateofmeeting as 6/18/2007, the includeckbox
would be checked. For those records that do not have dateofmeeting as
6/18/2007, the includeckbox would not be checked.

Thanks in advance.

First, you'll need to return a field in your query that indicates if the
date value is equal to what was entered. Set up your query something like
this:

SELECT [field1],[field2],IIf([field3]=[Enter meeting date], True, False) As
CheckOn
FROM

...

This should prompt you for the date when the report opens. Then, in your
report, bind the includeckbox control to the new [CheckOn] field.

Carl Rapson