Help!

I have a Phone number field that consist of HO, H2, M1, M2, WO, and W2 as the type of Phone.


HO and H2 = Home Number 1 and 2
M1 and M2 = Mobile 1 and 2
WO and W2 = Work 1 and 2

I have pulled in the Home phone in the Detail section but when I put in Mobile phone using the formula

If {Address.PhoneType} = "M1" then
if {Address.PhoneArea} <> 0 then
(ToText({Address.PhoneArea}, "###"))&"-"&(ToText({Address.PhoneExchange}, "###"))&"-"&(ToText({Address.PhoneLast4}, "0000"))

It have duplication for example

Name       Home Phone          CellPhone
ABC        222-333-4444
ABC        222-333-4444
ABC        222-333-4444
ABC        222-333-4444
ABC        222-333-4444       555-666-7777
ABC        222-333-4444

I know that the reason it showed up that way is because the 555-666-7777 is the M1 that I wanted. How can I just show that row where ABC have HOme and Mobile only?

Thanks!

I actually did it that way but then it will only show me 1 result instead.

For example:

Name            Home             CellPhone    Appt
Big Head      123-456-7890    323-528-7888 9/3/2015 1pm


It should show like this

Name            Home             CellPhone    Appt
Big Head      123-456-7890    323-528-7888 9/3/2015 1pm
Big Head      123-456-7890    323-528-7888 9/3/2015 2pm


That's why i put that in the Detail section. Any ideas?

Add another group on appointment date and move the fields into that group footer.

-Dell

That fixed it! Thanks!!!!