seanruk
Last Activity: Jan 31 '12, 11:28 AM
Joined: Jan 30 '12
Location:
-
That was the answer, thanks -
Thank you for your quick reply. I will test this and let you know how I get on but it seems so obvious now :o)Leave a comment:
-
Disctinct query plus total column value
Hi, hopefully someone can help me with this query. Basically I have 3 columns in 1 table, they are:
NAME
SIZE
NUMBER
I need a query that will return the NAME and SIZE as distinct values and then add the NUMBER together to give a total. An example of the results before the query would be:
NAME SIZE NUMBER
Joe A 1
Stan A 6
Joe B 3
Joe C 12...
No activity results to display
Leave a comment: