Combining fields in a report

S

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?
 
T

Tom Lake

Steve Hayes said:
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?
Click to expand...

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
 
Top