Concatenating a UniqueID

[ADAM_AUS]

I am trying to create a uniqueID based on 2 fields.

I am unsure as to where it is best to do this. In a table or in a query?

The field names are
[tblWOProgressDetail].[Activity]
and
[tblWOProgressDetail].[ResourceID]

The output I am after is the same function as I would do in excel by Concatenating the 2 fields with a " " inbetween to give an output like;

A1000 01ICGEN
A1000 01ICSUP
A1001 01ICGEN

etc.

Any help will be greatly appriciated as I am still getting my head around how to think like an Access thinker rather than Excel.

Regards,

Adam_AUS

 

[neileg]

You can't do it in a table. You can do it in a form or a query. But you don't need to store this since you can calculate it any time you need it

=[Activity] & " " & [ResourceID]

This may be a unique ID but don't even think about using it as the primary key.

 

[ADAM_AUS]

Brilliant. Thanks. Quick question. At what stage should I expect to be able to this this with out asking simple stupid questions. So far it is a slow process...

 

[dkinley]

No question is stupid but expect to spend at least 3 years before you will be self-sufficient. Even then, you'll have questions but you'll think they are intelligent questions

Then once asked, everyone will chime in and remind you about how unintelligent the question really is.

-dK

 

[dkinley]

Also ...

I am still getting my head around how to think like an Access thinker rather than Excel.

Spreadsheet thinkers think in 2D ... Database thinkers think in 3D.


Make that thinking in ND.

=dK