I'm trying to make a field in my report (pulling from a query) that will list all of the text in several fields separated by commas.
I have a text box where the control source is:
=[CA772N] & ", " & [CA772EPN] & ", " & [CA772IDN] & ", " & [CA772GCN] & ", " & [CA772PRN]
All it gives me is "#error" when I run the report, and...
cfwillia
Last Activity: Apr 30 '07, 07:59 PM
Joined: Mar 22 '07
Location:
-
Combining Text Values in a Report
-
the "Not (IsNull)" worked great! thanks! -
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).Leave a comment:
-
Check Box in Report Based on a Date in the Database
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,...
No activity results to display
Leave a comment: