Hello guys
New to this forum and new to access (fairly)
I'm having to tweak an existing database so am trying to play with what I already have
there is a sales table which is set up roughly along th elines of
Transaction No., Product 1 Price, Product 1 Type , Product 2 Price, Product 2 Type
I need to group all the sales made by product type ( regardless of whether they are the first or sceond line of a transcation and total each group as they need to be coded seperately,
eg for the lines,
1, £5, apples, £1, pears
2, £4, bananas, £2, apples
3, £2, pears
I need to show
Apples T1, £5 Total £7
T2 £2
Pears T1 £1 Total £3
T3 £2
Is this possible? Any help would be much appreciated.
EB2!
New to this forum and new to access (fairly)
I'm having to tweak an existing database so am trying to play with what I already have
there is a sales table which is set up roughly along th elines of
Transaction No., Product 1 Price, Product 1 Type , Product 2 Price, Product 2 Type
I need to group all the sales made by product type ( regardless of whether they are the first or sceond line of a transcation and total each group as they need to be coded seperately,
eg for the lines,
1, £5, apples, £1, pears
2, £4, bananas, £2, apples
3, £2, pears
I need to show
Apples T1, £5 Total £7
T2 £2
Pears T1 £1 Total £3
T3 £2
Is this possible? Any help would be much appreciated.
EB2!