Search results for query: *

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...