Re: [MSAccessProfessionals] Subreport not returning rows

Thanks for including the previous message. 

Find the reason. I think I asked very early on if the form was closing. When the report has displayed you can open the debug window (press Ctrl+G) and enter:

? [forms]![frmWorkOrderlog]![txtDatefrom]

What do you see?

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Art Lorenzini via Groups.Io <dbalorenzini=yahoo.com@groups.io>
Sent: Monday, March 30, 2020 12:18 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Subreport not returning rows

 

This is the query for the sub report:

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;

For some reason I am losing the contents of the txtDatefrom and txtDateTo when the subreport fires up.

With Warm Regards,

 

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265  Ext. 130

Fax (605)964-1070

"Valar Dohaeris"

On Monday, March 30, 2020, 11:59:09 AM CDT, Duane Hookom <duanehookom@hotmail.com> wrote:

Art,

You need to include all of the significant information from previous posts so we know what you are referring to. 

Can you provide the SQL view of the subreport's record source?

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Art Lorenzini via Groups.Io <dbalorenzini=yahoo.com@groups.io>
Sent: Monday, March 30, 2020 11:46 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Subreport not returning rows

 

For whatever reason, the subreport query loses the date criteria which is obtained via the main report query.

With Warm Regards,

 

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265  Ext. 130

Fax (605)964-1070

"Valar Dohaeris"

On Wednesday, March 25, 2020, 11:17:08 PM CDT, Arnelito Puzon <agpuzon@gmail.com> wrote:

why not move the HAVING clause to WHERE clause of the query.