syntax of call in my query?

L

lpj

what is the correct way to put a call in my query (this
global variable value is the 'having' clause). Thanks!
without the call i have no problems but then when i add
the call i get an error msg about 'amount' not being in my
aggregate function... i know it's my syntax.. but how do i
fix it? thanks! here is my query (i'm not including the
entire query.. it's on another laptop.. and too much to
type.. im starting with the 'group by')

GROUP BY tblRefunds.Company, tblRefunds.ID,
tblRefunds.Date, tblRefunds.TaxType,
tblRfundAmtsToAccts.GLAccountNo,
tblRfundsAmtsToAccts.Amount=getglobal(mysql)

ORDER BY tblRefunds.TaxType Desc;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top