How to add 3 fields into a new field ?

[manoskok]

Please help
I have a table where I enter information about a specific microbiological analysis,
tblDigmatol (DigmatolID, CustomerID, Date, etc)

What I need is to have a calculated field in that table consisted from the above 3 fields together in one word (eg DigmatolID=23, CustomerID=AFGT, Date=3/5/01)

How can I make the table (tblDigmatol) for each new entry
to get all the above 3 fields toghether (23AFDT3/5/01) and put this information
as text into a new field ?

Thanks in advance

 

[JoeMiller]

You can't do this at the table level, you'll have to do it in an event on your form for entering data. However I must say that this is not a very good idea to put data together like that and store it in a field. You can always store them separately and put them together via queries for presentation purposes. But storing multiple data in one field like that breaks First Normal Form rules.

HTH Joe Miller
joe.miller@flotech.net

 

[manoskok]

Thanks a lot for your help on this.
My idea was to have the db to construct automatically
a specific field in order to identify each analysis in addition to the table primary field (DigmatolID).
Thanks again.