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 performed this calculation, but I am more familiar with Access, therefore, I would like to solve this problem in Access.
Is it possible to change the figures in the NetCharge column, without creating another column? Ultimately, I am using this data in DI-Diver, but I require the figures to be correct in order to produce accurate reports.
Thanks in advance for your help.
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 performed this calculation, but I am more familiar with Access, therefore, I would like to solve this problem in Access.
Is it possible to change the figures in the NetCharge column, without creating another column? Ultimately, I am using this data in DI-Diver, but I require the figures to be correct in order to produce accurate reports.
Thanks in advance for your help.