Hi Duane:
I just checked out the crosstab query. It appears to allow me to put up to three fields of information on the left hand side and one field of information as a column across the top.
I set the rows to be unique for Contact_ID, Contact_Lastname,Contact_Firstname and email for column.
It put every email I have across the top as column headings with the number of occurrences for each row.
Looks like a pivot chart on steroids but not what I am seeking.
I uploaded an example of what I want to get out. look at the email and status columns. Right now, I get one line for each email and one for each status with Name and address duplicated.
Thanks...
__._,_.___
Posted by: jan.hertzsch@gmail.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar