On 31/10/2002 18:26 Scott Taylor wrote: > > Anyone know how to use Visual Design Query in PgAccess? (There are no > tutorials) > > I am trying to write a SL tax report but not sure of what to put in the > "critreria" box: > > These are the tables I trying to use: > > (trans_id) > (chart_id) > (amount) > (transdate) > > I want to have a query for tax paid where, if a trans_id has a chart_id > of > 10074 (my tax account), return all entries that have that trans_id and > are <0 > (which would show only the the tax and net amounts) with a transdate > between > 2 dates. > > Any takers?
Don't know about Visual Builder but I think the SQL you want to use is something like: select amount, transdate from acc_trans where chart_id in (select id as chart_id from chart where accno = '1234') and amount < 0 replace 1234 with the account number of your tax account shown in the Chart of Accounts. HTH. -- Paul Thomas Thomas Micro Systems Limited http://www.tmsl.demon.co.uk
