Thanks for that, but I have a number of records (with different reference numbers) that need to be consolidated on the same report. How can this be achieved?
For example:
Ref Company Date Amount
456/100/001C Bloggs & Co 12/12/03 £2000
456/100/001LC Bloggs & Co...
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...
Hi Joe and DR,
Both of your suggestions worked great, but as I want to update the current NetCharge column, I think I'll go with the UPDATE.
Thanks again,
Amanda.
Hi John,
The data looks like this (disgarding about 20 other columns):
ID NetCharge RowType
1 30 C
2 215.3 C
3 15.4 I
etc
Therefore, the NetCharge figures in ID1 and ID2 need to be -30 and -215.3 respectively. At present, these...
Hi,
I'm hoping someone can help me.
Working in Access 97, my aim is to negate numbers in a given column, based upon criteria in another column.
i.e. Where RowType = C, negate the figure in NetCharge
I'm working with credit and debit figures pulled originally from a FoxPro application which...
Hi,
I wonder if anyone can help me regarding the design of a user interface to be used in conjunction with DI-Diver by Dimensional Insight?
I am in the process of researching this data analysis tool, but in order to be incorporated into the business, users would need to access the data models...
Hi,
I am in the process of researching DI-Diver, using test data to see if it meets business needs.
In order to be incorporated into the business, users would need to access the data models, and at present, I am doubtful that the majority have the technical ability required to dive into the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.