Format

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

Guest

I field that is 6 digits long. I would only like to show the first 4 digits on my report. How can I do this

Thanks

Josh
 
Josh said:
I field that is 6 digits long. I would only like to show the first 4
Click to expand...
digits on my report. How can I do this?

Left(CStr([NumField]),4)
 
You must log in or register to reply here.

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

Similar Threads

How do I do display xxx-xx-1234 in an access report 10
News Bank of England considers digital currency 4
Only first digit of a number shows on Report i.e., 600 shows 6 10
Windows 10 Activate windows now message 3
Format for Year 2
Windows 10 How to Activate Windows 10 to Remove Water Mark 9
How do I display the last 8 digits of a field on a report in Acce 1
On Print / On Format Event 5

Back
Top