what's wrong with my query?

[Guest]

mySQL is a global string which is the 'having' clause of my query... this
query is my report's record source.. my query is't seeing the clause.. i'm
getting a missing operator error message (on
tblCheckReqAmtsToAccts.GLAccountNo '" & mySQL & "')

SELECT tblCheckReq.ID AS [Req #], tblCheckReq.Date, tblCheckReq.Company,
tblCheckReq.State, tblCheckReq.TaxType, tblCheckReq.PaymentType,
tblCheckReq.TaxYear, Sum(tblCheckReqAmtsToAccts.Amount) AS Amount,
tblCheckReqAmtsToAccts.GLAccountNo, tblCheckReq.Issued
FROM tblCheckReq INNER JOIN tblCheckReqAmtsToAccts ON
tblCheckReq.ID=tblCheckReqAmtsToAccts.ID
WHERE tblCheckReq.DeletedCheckRequest=False
GROUP BY tblCheckReq.ID, tblCheckReq.Date, tblCheckReq.Company,
tblCheckReq.State, tblCheckReq.TaxType, tblCheckReq.PaymentType,
tblCheckReq.TaxYear, tblCheckReq.Issued, tblCheckReqAmtsToAccts.GLAccountNo
'" & mySQL & "'
ORDER BY tblCheckReq.ID DESC;

thanks!

 

[Guest]

Please Help! After more searching i did find that a variable cannot be passed
directly to a query.. so i modified my query.. but things are still not
good.. the error i am now receiving states that GLAccoutNo is not part of
aggregate function.. i added this to my global module:
Public Function GetGlobal(varname As String) As Variant
GetGlobal = Eval(varname)
End Function

and here is my new query:
SELECT tblCheckReq.ID AS [Req #], tblCheckReq.Date, tblCheckReq.Company,
tblCheckReq.State, tblCheckReq.TaxType, tblCheckReq.PaymentType,
tblCheckReq.TaxYear, Sum(tblCheckReqAmtsToAccts.Amount) AS Amount,
tblCheckReqAmtsToAccts.GLAccountNo, tblCheckReq.Issued
FROM tblCheckReq INNER JOIN tblCheckReqAmtsToAccts ON
tblCheckReq.ID=tblCheckReqAmtsToAccts.ID
WHERE tblCheckReq.DeletedCheckRequest=False
GROUP BY tblCheckReq.ID, tblCheckReq.Date, tblCheckReq.Company,
tblCheckReq.State, tblCheckReq.TaxType, tblCheckReq.PaymentType,
tblCheckReq.TaxYear, tblCheckReq.Issued,
tblCheckReqAmtsToAccts.GLAccountNo=GetGlobal("mySQL")
ORDER BY tblCheckReq.ID DESC;

 

[Guest]

RESOLVED.. : )

Please Help! After more searching i did find that a variable cannot be passed
directly to a query.. so i modified my query.. but things are still not
good.. the error i am now receiving states that GLAccoutNo is not part of
aggregate function.. i added this to my global module:
Public Function GetGlobal(varname As String) As Variant
GetGlobal = Eval(varname)
End Function

and here is my new query:
SELECT tblCheckReq.ID AS [Req #], tblCheckReq.Date, tblCheckReq.Company,
tblCheckReq.State, tblCheckReq.TaxType, tblCheckReq.PaymentType,
tblCheckReq.TaxYear, Sum(tblCheckReqAmtsToAccts.Amount) AS Amount,
tblCheckReqAmtsToAccts.GLAccountNo, tblCheckReq.Issued
FROM tblCheckReq INNER JOIN tblCheckReqAmtsToAccts ON
tblCheckReq.ID=tblCheckReqAmtsToAccts.ID
WHERE tblCheckReq.DeletedCheckRequest=False
GROUP BY tblCheckReq.ID, tblCheckReq.Date, tblCheckReq.Company,
tblCheckReq.State, tblCheckReq.TaxType, tblCheckReq.PaymentType,
tblCheckReq.TaxYear, tblCheckReq.Issued,
tblCheckReqAmtsToAccts.GLAccountNo=GetGlobal("mySQL")
ORDER BY tblCheckReq.ID DESC;

mySQL is a global string which is the 'having' clause of my query... this
query is my report's record source.. my query is't seeing the clause.. i'm
getting a missing operator error message (on
tblCheckReqAmtsToAccts.GLAccountNo '" & mySQL & "')

SELECT tblCheckReq.ID AS [Req #], tblCheckReq.Date, tblCheckReq.Company,
tblCheckReq.State, tblCheckReq.TaxType, tblCheckReq.PaymentType,
tblCheckReq.TaxYear, Sum(tblCheckReqAmtsToAccts.Amount) AS Amount,
tblCheckReqAmtsToAccts.GLAccountNo, tblCheckReq.Issued
FROM tblCheckReq INNER JOIN tblCheckReqAmtsToAccts ON
tblCheckReq.ID=tblCheckReqAmtsToAccts.ID
WHERE tblCheckReq.DeletedCheckRequest=False
GROUP BY tblCheckReq.ID, tblCheckReq.Date, tblCheckReq.Company,
tblCheckReq.State, tblCheckReq.TaxType, tblCheckReq.PaymentType,
tblCheckReq.TaxYear, tblCheckReq.Issued, tblCheckReqAmtsToAccts.GLAccountNo
'" & mySQL & "'
ORDER BY tblCheckReq.ID DESC;

thanks!