ACCESS FEED: RE: [MS_AccessPros] Re: Help with report

Rabu, 02 Januari 2013

RE: [MS_AccessPros] Re: Help with report

Katrina,

I rarely save any report with something in the Filter property. Try change the SQL view of qry_cargo to include the where condition:

SELECT tblPlanes.EDA, tblPlanes.Formal, tblPlanes.[Informal Entries Release], tblPlanes.[Enforcement Exams], tblPlanes.[Stratified Compliance Exams], tblPlanes.[ATS Compliance Exams], tblPlanes.[Intensive Exams], tblPlanes.[Agriculture Exams], tblPlanes.[Negative Exams], tblPlanes.[Positive Exams], tblPlanes.[SSPL/SIPL], tblPlanes.SSAC, tblPlanes.DOS, tblPlanes.[ATF 6A], tblPlanes.OGA, tblPlanes.Quotas, tblPlanes.[Duty Collected], tblPlanes.TIB, tblPlanes.[Inbond Arrivals], tblPlanes.[Inbond Closures], tblPlanes.[Inbond Departures], tblPlanes.[INS Issues], tblPlanes.[ATA Carnets], tblPlanes.[HS-7], tblPlanes.[CF 4455/4457], tblPlanes.[CF 214], tblPlanes.[CF 3299], tblPlanes.[CF 3311], tblPlanes.[CF 4647]
FROM tblPlanes
WHERE [EDA] Between [Forms]![frm_cargo_rng]![bdate] And [Forms]![frm_cargo_rng]![edate]
ORDER BY tblPlanes.EDA;

Then delete anything from the filter properties of the main and subreports.

Duane Hookom MVP
MS Access

----------------------------------------
> From: no_reply@yahoogroups.com
>
> I uploaded the same database (Austin Tracker - new working3) with more records in the tblPlanes. When I select different dates for example 04/01/12 through 04/30/12, the first page of the report shows the records I've selected; however, the second page shows other dates instead of only those between April 1st and April 30th. I've looked over the report and can't seem to find what it is I'm doing wrong that doesn't allow the subreport to also filter only those records between those dates.
>
> Thanks!
>
> Katrina
>
> --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
> >
> > The records displayed for me. Are you using the Print Preview mode?
> >
> > Duane Hookom MVP
> > MS Access
> >
> > ----------------------------------------
> > > From: no_reply@yahoogroups.com
> > >
> > > Duane,
> > >
> > > I took out the EDA field in the Link Master/Child, and it still doesn't display the records. The main reports displays the records based on the date selection I made on the frm_cargo; however, the same records should be displayed for those same dates in the subreport, and the subreport comes back blank. I'm not sure what else to do.
> > >
> > > Your help is greatly appreciated!
> > >
> > > Thanks!
> > >
> > > Katrina
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> > > >
> > > > I think your issue is that you have the Link Master/Child properties of the subreport set to the EDA field. I expect you want these blank.
> > > >
> > > > Duane Hookom MVP
> > > > MS Access
> > > > ----------------------------------------
> > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > From: no_reply@yahoogroups.com
> > > > > Date: Mon, 31 Dec 2012 17:51:43 +0000
> > > > > Subject: [MS_AccessPros] Help with report
> > > > >
> > > > > Hello all!
> > > > >
> > > > > I have a database I'm working on, and have run into a problem. I have a report that displays certain fields based on a query. In that report I have a subreport that I want displayed at the bottom of the report. The top portion of the report is filtered based on the date selection made on the frm_cargo. What I would like is to also have the fields in the subreport filtered based on that same selection. I entered the filter in the subreport; however, it does not display the information once the dates are selected. If someone could please look at my report and tell me what it might be I'm missing I would greatly appreciate it. I have uploaded the database into the Assistance Needed folder under Austin Tracker - New Working2.
> > > > >
> > > > > Thanks so much for your help!
> > > > >
> > > > > Katrina