need to combine two fields

[jwallace203]

I have a database for service jobs for a mobile detailing company. Some of our customers have 2 cars but they are not always serviced at the same time. I have 2 fields (car 1, car2) in my order details table so that I know which car was serviced for that order. I have a report that automatically fills in information for that job when I type the customer name and order number. I would like it to also populate the car for that order w/o having car 1 and car 2 visible on the report. I would like a label, Car Serviced, and for that to pull from fields car 1 and car 2. How can I do that?
Thank you

[June7]

Is it allowed for both fields to have data for same record?

You can have label and a textbox for car1 then another textbox without label for car2 next to it.

You can concatenate the two fields with expression in query or textbox: [car1] & Iif(Not IsNull([car1]),", ","") & [car2]