how to create an autocalc field

E

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.
 
E

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
 
E

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...
Click to expand...
[quoted text clipped - 6 lines]
VANCBCZK0MD from another table field
VANCBC08DS2 from another table field.
Click to expand...
Click to expand...
 
J

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.
Click to expand...

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]
 
Top