Hi Sarah,
You need to make a change to the reports data source,
which is usually a query.
In the query, add a field like,
Comb: [MyTable]![SurName] & " " & [MyTable]![Phone]
Replace MyTable with the name of your source table
and Surname and Phone with the fieldnames that you use.
Hope that helps.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "novice012000" wrote:
>
> Is there any way to create an input mask for a telephone number and text in one field on a report . The input mask for the telephone number is \(999") "000\-0000" ext "99999;;_"", I would like to print a name before the tel#. I dont want to use 2 fields todo this, because I want them separated by only one space and since the name can be a variable length I can not use 2 fields. How to I add a text mask to the beginning of the tel# mask.? I tried using '?', but it did not work.
> Thanks in advance for any help.
>
> Sarah
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar