accounting query

CHAOSinACT

Registered User.
Local time
Today, 23:31
Joined
Mar 18, 2009
Messages
235
ok...
i have a database linking to MYOB DATA (actually 3 myob files which will go just great lol...)

prob is where trying to rebuild job transactions from raw tables. when you print a job transaction report from myob it list a "debit" and "credit" column for transactions. in reality there is one field in a table that is either positive or negative and myob separates them on the fly. i can get either by setting the where clause to >0 or <0 but not in same query. i really want them in same query and it leaves either column blank if it fails test....

how do i do this?? i know it should be simple but doesn't seem to go with my guesses. happy to be pointed to another web site (i don't mind reading)
 
Chaos,

If I understand you correctly, you can make a couple of calculated columns in your query, like this...

Debit: IIf([YourAmountField]<0,Abs([YourAmountField]),Null)
Credit: IIf([YourAmountField]>=0,[YourAmountField],Null)
 
i suppose that saying i want to have your babies is over the top, but your a legend!!!!! love straight forward answers!!! sorted it right away. i tried to nest a VBA statement there doing something similar, didn't want to work but that did!!!

Thanks again!!
 

Users who are viewing this thread

Back
Top Bottom