Default value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top