Re: [MSAccessProfessionals] Subreport not returning rows

if the main report query doesn't have a problem, why not copy same structure of
main query to subquery, moving the condition to WHERE clause:

SELECT Count(SV00300.Service_Call_ID) AS CountOfService_Call_ID, SV00300.Type_of_Problem
FROM SV00300
WHERE  (((SV00300.DATE1)>=[forms]![frmWorkOrderlog]![txtDatefrom] And (SV00300.DATE1)<=[forms]![frmWorkOrderlog]![txtDateto]))
GROUP BY SV00300.Type_of_Problem;

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115441) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_