Combining fields in a report

[Steve Hayes]

How can I combine fields in a report?

For example, if a date has been entered in three separate fields for Year,
Month and Day, and I want to print it in a report in the form of YYYY-MM-DD,
how do I create the combined field?

 

[Tom Lake]

How can I combine fields in a report?

For example, if a date has been entered in three separate fields for Year,
Month and Day, and I want to print it in a report in the form of
YYYY-MM-DD,
how do I create the combined field?

Create a fourth field with record source like this:

= [YearField] & "-" & [MonthField] & "-" & [DayField]

Replace the sample field names I gave with your own actual field names.

Tom Lake