Subreport not returning all records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sandy - 24 Jan 2006 19:43 GMT

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!

Signature

Sandy

Reply to this Message

Ofer - 24 Jan 2006 20:18 GMT

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

Signature

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

> Hello -
>
[quoted text clipped - 10 lines]
>
> Any suggestions on how to accomplish this will be appreciated!

Reply to this Message

Sandy - 25 Jan 2006 14:29 GMT

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?

Signature

Sandy

> 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
[quoted text clipped - 13 lines]
> >
> > Any suggestions on how to accomplish this will be appreciated!

Reply to this Message