Check Box in Report Based on a Date in the Database

[cfwillia]

Hi,
I'm trying to make a Report that will show a check box as checked off if there is a date in a certain field for the given record (instead of the field in the database being yes/no, each field has a date). Also, sometimes the check box may have to be checked when a date is in one field or another field (or like 5 fields). When there is no date in the field or any of the fields, the check box should not be checked.

Alternatively, would I be able to make a field in a database or query where it is a check box and it is checked off if the dates are present, and then use this check box in the report?

Any ideas?

Thanks!

[cfwillia]

Also, it doesn't matter what the date is, just that there is one present in the field (the field is set as a date type).

[Denburt]

I think I would take your second option add a yes/No field to your table then add the checkbox to your form where they enter the data you can even hide it so noone sees it. Then when they update any of your date fields with a date you can change the checkbox to True. This part can be done in code and I would gladly walk you through it.

[NeoPa]

Assuming your 5 date fields are called dat1 through dat5 then your CheckBox on the report could be set to :

=Not (IsNull([dat1]) AND IsNull([dat2]) AND IsNull([dat3]) AND IsNull([dat4]) AND IsNull([dat5]))

Performance- and simplicity-wise, it's probably better to use this approach, although the difference in most cases is negligible so it's really down to your own preference.

[cfwillia]

the "Not (IsNull)" worked great! thanks!

[NeoPa]

Not a problem. We're glad we could help you :)