Re: [MSAccessProfessionals] Subreport not returning rows

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.