Default value

D

dvorasnell

How do I create a default value for a 4 digit entry, letting the digis fill
right to left, but showing 00 in all unused places. For instance, I need to
track the age of acocunts in days. But for sorting purposes, I want the
value to read 0001, 0002 etc. How would I express a default value format for
this?
 
K

kingston via AccessMonster.com

Use a query to display the value with leading zeros in a calculated field and
sort on this new field:

DaysField: Right("0000" & [OriginalField],4)
 
Top