Combinding Fields in Table

[Guest]

Is there a way to have 1 field be a combination of several fields in the same
table?
I have 3 fields, program name, date, and the unique identifier number for
the record. I want a 4th field that is a combination of the three. Example:
ProjectA-04042006-01. Is there a way to do this as each row is created?

 

[Armen Stein]

Is there a way to have 1 field be a combination of several fields in the same
table?
I have 3 fields, program name, date, and the unique identifier number for
the record. I want a 4th field that is a combination of the three. Example:
ProjectA-04042006-01. Is there a way to do this as each row is created?

Hi Jenn,

You wouldn't do this in a table - that would be storing redundant data.
In a query, you can make a "calculated" field in a query like this:
CombinedID: [ProjectName] & [ProjectDate] & [ProjectNbr]

Now you can use the query instead of the table.

If you just need the combined value to show up in a form or report, you
can create a textbox control with the same formula above.