Administrator: Receipts Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

I've Got Your Number

If you click on the Record Source, you can open the new query with the three-dot builder. Create a new field to concatenate the Name and Phone number.

 

The new code will look like this:

 

NameAndPhone: [Phone] & " " & [LastName] & ", " & [FirstName]

 

In the Criteria add the Like parameter:

 

Like "*" & [Enter the name or phone] & "*"

 

Save the query.

Home ->View ->Report Design