Hello - this should be an easy one for you gurus!
I am in Access 97. In my table, I have a STORE column that is formatted in the design view to be 3 digits (i.e. Store "1" would show as "001"). In the query based on the table, this format is also specified for the STORE field.
My report that is based on that query is grouped by STORE. The STORE footer section has a calculated field:
="555-"&[STORE]&"-020"
Because I formatted it in both the table and query, I would think that the report would show 555-001-020, but it is showing 555-1-020.
I've tried formatting the field to 000-000-000, but it isn't working.
What am I doing wrong? Thanks in advance for your reply.
I am in Access 97. In my table, I have a STORE column that is formatted in the design view to be 3 digits (i.e. Store "1" would show as "001"). In the query based on the table, this format is also specified for the STORE field.
My report that is based on that query is grouped by STORE. The STORE footer section has a calculated field:
="555-"&[STORE]&"-020"
Because I formatted it in both the table and query, I would think that the report would show 555-001-020, but it is showing 555-1-020.
I've tried formatting the field to 000-000-000, but it isn't working.
What am I doing wrong? Thanks in advance for your reply.
