Hi,
I hope someone can help me achieve a report that i'm currently struggling with...
I am trying to consolidate data currently in the format:
Ref Company Date Amount
456/100/001C Bloggs & Co 12/12/03 £2000
456/100/001LC Bloggs & Co 12/12/03 £4000
456/100/001LT Bloggs & Co 12/12/03 £1500
to be output as:
Ref Company Date Amount
456/100/001 Bloggs & Co 12/12/03 £75000
Is this possible? If yes, please can you tell me how can achieve it? I have a number of records that need to be consolidated in this way.
Many thanks,
Amanda
I hope someone can help me achieve a report that i'm currently struggling with...
I am trying to consolidate data currently in the format:
Ref Company Date Amount
456/100/001C Bloggs & Co 12/12/03 £2000
456/100/001LC Bloggs & Co 12/12/03 £4000
456/100/001LT Bloggs & Co 12/12/03 £1500
to be output as:
Ref Company Date Amount
456/100/001 Bloggs & Co 12/12/03 £75000
Is this possible? If yes, please can you tell me how can achieve it? I have a number of records that need to be consolidated in this way.
Many thanks,
Amanda