make month, day and year into one field

H

Heidi

I have MO, DAY, and YR fields as separate fields. How do I merge them into
one field called TRIP_START_DATE?
 
H

Heidi

Perfect. Thank you.

KARL DEWEY said:
TRIP_START_DATE: DateSerial([YR], [MO], [DAY])
--
Build a little, test a little.


Heidi said:
I have MO, DAY, and YR fields as separate fields. How do I merge them into
one field called TRIP_START_DATE?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge skipping records/sending one at a time 0
ASK Field Formatting 1
Grouping Names in Mail Merge 0
How to combine year and month into one field 3
Start a mail merge upon opening the document 1
Supress blank fields in merged doc 0
Aggregate function 2
Help!! Extracting data from a single field 2

Top