Design View http://imgur.com/a/OitgN
Datasheet http://imgur.com/a/8bp9z
I want to provide a list of account numbers and see if those accounts have the RPSs (Restricted Product Set, essentially 1 of 400+ codes) I have listed in the criteria, 1, 142, 260, 280, 318, 373, 374, 376, 401.
I want the query to return a column for each account number i provide (in an excel linked table) and 9 rows, 1 for each RPS I have listed. I thought this was the point of a cross tab query, to be able to quickly evaluate data. If all the counts were in the same 9 rows, i could quickly see if an account is missing one of these RPSs. Instead, the query is returning 9 rows for EACH account number, which is no more helpful than if i just created a select query.
What am i doing wrong? This is my first attempt at a crosstab query. Thanks in advance for your help.