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