Help with formatting combined data

[cmartin19]

I need to set up an identifier field that contians the date and unit identifier from another field. In yymmdd-[Unit_ID] format, I get the date to output correctly, but I need to get the Unit_ID data from another field. Any suggestions appreciated.

 

[hi there]

i'm not sure if i'm understanding your question correctly, but you might want to use the ampersand "&" wildcard to concatenate the 2 fields you want together, however you can't add calculated fields to tables. you'd need to do this in a query or directly in a calculated control on a form. you could then force the format to whatever you wanted using the FORMAT function.

hope that helps

 

[cmartin19]

more info

I am trying to get the output to look like 030214-00001 once I have finished. A calculation doesn't seem to be right. If I try to use one field to show 2 types of data from different fields I get a data mismatch error.
Please correct me if I'm wrong, I am very new to this.

To re iterate my problem I have 2 fields in a table a date field that is formatted yymmdd, and a Unit ID field that is general text.

 

[Pat Hartman]

You can output the field in a query.

Select Format(YourDate, "yymmdd") & "-" & [Unit_ID] as Combinedfield
From YourTable;

 

[cmartin19]

That works for my purposes thanks to all who helped