My “KofC” table has a “Postal Code” field that contains Zip Codes in 10 digit format “99999-9999”. I want to only use the first five digits in a report. How to I make that happen? What do I enter in the Data Field in the properties section of the report?
Use function LEFT: =LEFT([Postal Code];5)
Thanks so much!!! I had everything right except I was using a comma instead of a semi-colon