calculating text fields and date fields together possible? i'm getting an error. i'm trying to calculate a unique number...

help be nice....! thanks

If you need to perform calculations on a field it should be defined as numeric.

You can extract the numeric portion of a text by using the Val() function. I think this will only work if the numeric portion is leading (123zbc not zbc123). Look it up.