Export Field Name

[LJG]

Can anyone advise how I can change the name of a field when I create an
export file.

I have a table who's data is exported

orderID
qty
dacolID
userID

I have to create a joined field,

[orderID]&""&[userID] as orderID2

I then need to import this data into another database who's field names are
named the same, but now I have a field called orderID2

I have change the name in the properties to orderID, but that only works if
I run as a query in the database, not when it is exported, to keeps the name
orderID2

Any suggestions appreciated

Thanks

 

[Rick B]

Are you going to export all three fields (orderID, userID, and orderID2)?

If so, you are breaking the cardinal rule of normalized database design.
You don't store redundant information.

Just store the two fields. In your queries, reports, and forms you can
combine them if you want for display purposes.

Each field in a database should contain one piece of information. You are
trying to shove two types of data into one field AND trying to store
redundant information. That's a double no-no.