Query Stuck

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

When I run my query it stuck is it possible that i can debug it

SELECT TOP 1 tblCredits.OPR, Min(tbl_CRCDollars.SumOfAMOUNT) AS
MinOfSumOfAMOUNT, Avg(tblCredits.Credit) AS AvgOfCredit,
Count(tblCredits.OPR) AS CountOfOPR1,
tbl_WorkingCountDays.CountOfREPORT_DATE,
([qry_TopDollarAvgDays]![CountOfOPR])/([qry_TopDollarAvgDays]![CountOfREPORT_DATE])
AS AvgNum INTO tbl_TopRep
FROM tbl_CRCDollars, qry_TopDollarAvgDays, tbl_WorkingCountDays,
tblCredits
WHERE (((tblCredits.ADJRSN) Not Like "4*"))
GROUP BY tblCredits.OPR, tbl_WorkingCountDays.CountOfREPORT_DATE,
([qry_TopDollarAvgDays]![CountOfOPR])/([qry_TopDollarAvgDays]![CountOfREPORT_DATE])
ORDER BY Min(tbl_CRCDollars.SumOfAMOUNT);

Thank You
 
Hi Anna,
There is no real debugger for queries in Access. I would suggest you start
another query but don't include any WHERE, GROUP BY, or ORDER BY clauses
until you get the SELECT query working. You might even cut out some of the
aggregate functions at first. In other words, build your query slowly, one
successful step after the other.
When I run my query it stuck is it possible that i can debug it

SELECT TOP 1 tblCredits.OPR, Min(tbl_CRCDollars.SumOfAMOUNT) AS
MinOfSumOfAMOUNT, Avg(tblCredits.Credit) AS AvgOfCredit,
Count(tblCredits.OPR) AS CountOfOPR1,
tbl_WorkingCountDays.CountOfREPORT_DATE,
([qry_TopDollarAvgDays]![CountOfOPR])/([qry_TopDollarAvgDays]![CountOfREPORT_DATE])
AS AvgNum INTO tbl_TopRep
FROM tbl_CRCDollars, qry_TopDollarAvgDays, tbl_WorkingCountDays,
tblCredits
WHERE (((tblCredits.ADJRSN) Not Like "4*"))
GROUP BY tblCredits.OPR, tbl_WorkingCountDays.CountOfREPORT_DATE,
([qry_TopDollarAvgDays]![CountOfOPR])/([qry_TopDollarAvgDays]![CountOfREPORT_DATE])
ORDER BY Min(tbl_CRCDollars.SumOfAMOUNT);

Thank You
Click to expand...
 
Back
Top