Combining fields in a report

  • Thread starter Thread starter Steve Hayes
  • Start date Start date
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?
 
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
 
Back
Top