Subreport not returning all records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello -

I have a subreport based on the following query:

SELECT CallType, Count(*) AS NumOf
FROM qryOne
GROUP BY [CallType];

I need it to return all CallType categories and if they're zero, indicate a
zero next to the category name. Currently, it is just returning categories
that are greater than zero. I tried putting a "Where CallType >= 0" before
the Group By but I get an error message saying it is too complex.

Any suggestions on how to accomplish this will be appreciated!
 
Check the SQL of the "qryOne" Query, mybe there is a criteria in this query
that is greater the 0, I assume "qryOne" it's a query because of the name
 
Thanks for responding, Ofer!

Your assumption is correct. I checked the criteria in qryOne, however, and
it doesn't have any restriction that it be greater than 0.

Any other thoughts?
--
Sandy


Ofer said:
Check the SQL of the "qryOne" Query, mybe there is a criteria in this query
that is greater the 0, I assume "qryOne" it's a query because of the name

--
\\// Live Long and Prosper \\//
BS"D


Sandy said:
Hello -

I have a subreport based on the following query:

SELECT CallType, Count(*) AS NumOf
FROM qryOne
GROUP BY [CallType];

I need it to return all CallType categories and if they're zero, indicate a
zero next to the category name. Currently, it is just returning categories
that are greater than zero. I tried putting a "Where CallType >= 0" before
the Group By but I get an error message saying it is too complex.

Any suggestions on how to accomplish this will be appreciated!
Click to expand...
Click to expand...
 
Back
Top