unique references

[DanHolland]

Hi is there a way of merging 2 fields together to create an additional field

my database consists of 4 main tables (in order of relationships)

*HeadOfficeDetails

*SiteDetails

*ContainersOnSite *Contracts2015-2016

for example;

Account Reference: TEST
Site Number: 001

and the field i would like to have;

Site Reference: TEST/001

i would also like that when i add a new site to that account i will have TEST/002

is there a way of doing this or something similar

 

[Ranman256]

In a query, in an empty col....[field] & [field2]
Or
[field1] * [field32]

 

[DanHolland]

In a query, in an empty col....[field] & [field2]
Or
[field1] * [field32]

thanks for the quick reply

also is there a possibility of having the following

TEST1/001
TEST2/001

so that the first site on each of the records has 001 and the second 002 and so on?

 

[Ranman256]

that is a division, is that what you want?

or concatination
= [TEST1] & "/" & "001"

 

[DanHolland]

that is a division, is that what you want?

or concatination
= [TEST1] & "/" & "001"

id like each site to have a unique reference that is made up of the Account Reference and a unique number for that site for example an account which has 2 sites would work like this; (first site for each account is always 001 and ascending from there)

RHMP/001
RHMP/002

AASX/001
AASX/002