M
MB
I'm not sure if this is a query question or a reports question. I have a
database where the table has an input mask to include the area code for the
telephone numbers. The report (based on a query) shows the telephone
numbers, but I'm wondering if there is a way that the report will result with
just the local number (excluding the area code) because we have reports that
all are in the same area code.
I tried changing the input mask on the properties of the field in the report
design, but that didn't work. What do I need to do?
Working with Access 2003.
Thank you!
database where the table has an input mask to include the area code for the
telephone numbers. The report (based on a query) shows the telephone
numbers, but I'm wondering if there is a way that the report will result with
just the local number (excluding the area code) because we have reports that
all are in the same area code.
I tried changing the input mask on the properties of the field in the report
design, but that didn't work. What do I need to do?
Working with Access 2003.
Thank you!