Creating Table values using values from another table

[Danialle]

I am trying to create an index number using values in another table. I need to be able to concatinate multiple values and store them as a single value in a table. For Example:
object type - wm
street index - 173
Block number - 200
Incremental # - 001

creates a value of wm173200001 to be stored.

Any Ideas? Thanks

Danialle

 

[AlexMidd]

You could either use an update query or code to concatenate the fields.

In an update query, add the field you want for the index and put in the Change to row soemthing like

[object type] & [street index] & [Block number] & [Incremental]

You can do similar things with SQL or simple recordset handling using DAO in VB code. Not a trivial subject and needs some reading up. I imagine there will be something in past posts/FAQs about this.

Have fun! )

Alex Middleton