Hello,
Im stuck and need some help formatting a field in my append-query.
Example:
50.00
Need it to be at least 7 digits with leading zeros and no decimals
So it would be "0005000"
Also the field in my table were I need to store this value is TEXT.
Does anyone know if this is possible?
Mike
Im stuck and need some help formatting a field in my append-query.
Example:
50.00
Need it to be at least 7 digits with leading zeros and no decimals
So it would be "0005000"
Also the field in my table were I need to store this value is TEXT.
Does anyone know if this is possible?
Mike