Hello Everyone!
i have Guardian tbl and their Phone Numbers like this
Phone Types Phone#
Mobile ############
Landline ############
what i want is make a crosstab query to show phone # as columns with phone Type headings
I used phone No's as Value and in Total used First and Last but but some Guardians have two or more Mobile and Landlines how can i show all phone numbers ?
i have Guardian tbl and their Phone Numbers like this
Phone Types Phone#
Mobile ############
Landline ############
what i want is make a crosstab query to show phone # as columns with phone Type headings
I used phone No's as Value and in Total used First and Last but but some Guardians have two or more Mobile and Landlines how can i show all phone numbers ?