G
Guest
Hi, I have a small table which I would like to base a query from.
columns
sales id, date, quantity
The quantity column will have a value of 1,2,or 3. i've set the perameters
to search for a specific sales id and date range but i would like to create
three new columns in the query to pull the total
number for each quantity value 1.2 and 3. This would be a one line summary
of counts for a specific sales id.
I would like the outcome to look something like this.
Sales Id, total records in quantity, total of 1's from quantity, total of
2's from quantity, total of 3's from quantity.
Thanks for the help!
BL
columns
sales id, date, quantity
The quantity column will have a value of 1,2,or 3. i've set the perameters
to search for a specific sales id and date range but i would like to create
three new columns in the query to pull the total
number for each quantity value 1.2 and 3. This would be a one line summary
of counts for a specific sales id.
I would like the outcome to look something like this.
Sales Id, total records in quantity, total of 1's from quantity, total of
2's from quantity, total of 3's from quantity.
Thanks for the help!
BL