how to create an autocalc field

[emerlita]

I want to create something like this...

"5/T1ZF/VANCBCZK0MD/VANCBC08DS2"

where

5 is incremental
T1ZF is derived from another table field
VANCBCZK0MD from another table field
VANCBC08DS2 from another table field.

 

[evilcowstare via AccessMonster.com]

Is 5 incremental because its an autonumber?

Create a txt box, Go to record source and click .. bit next to it, then go to
expression.
Use the navigation to locate each part and add the calculation between so it
will be something like....

[Table1][Number5Field] / [Table2/TIZF Field] / [Table3/VANCBCZK0MD Field] etc

Hope this helps a bit

 

[evilcowstare via AccessMonster.com]

Bear in mind that usually you would get the calculations from a form rather
then the table as it wont know what record in the table you want to use

Is 5 incremental because its an autonumber?

Create a txt box, Go to record source and click .. bit next to it, then go to
expression.
Use the navigation to locate each part and add the calculation between so it
will be something like....

[Table1][Number5Field] / [Table2/TIZF Field] / [Table3/VANCBCZK0MD Field] etc

Hope this helps a bit

I want to create something like this...

[quoted text clipped - 6 lines]

VANCBCZK0MD from another table field
VANCBC08DS2 from another table field.

 

[John W. Vinson]

I want to create something like this...

"5/T1ZF/VANCBCZK0MD/VANCBC08DS2"

where

5 is incremental
T1ZF is derived from another table field
VANCBCZK0MD from another table field
VANCBC08DS2 from another table field.

Then this field SHOULD NOT EXIST.

It's redundant; you can generate it for display whenever you want, by
concatenating its components.

John W. Vinson [MVP]