format calculated fields?

[jive6243]

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.

 

[boblarson]

Sorry, but formatting within a table or query does not carry over to anything else.

You are on the right track, just a bit off:

You have - ="555-"&[STORE]&"-020"

but it should be ="555-" & Format([STORE],"000") &"-020"

 

[jive6243]

THAT DID IT!

THANK YOU SO MUCH!!!!! I KNEW I went to the right place with my question. You are the best!!!