Kamis, 21 Juli 2011

[MS_AccessPros] Re: Searching on 2 tables

 

Duane:
Figured out the sort
Thanx
Walter

--- In MS_Access_Professionals@yahoogroups.com, "nkpberk" <wgriffin48@...> wrote:
>
> Duane;
> That works! But... Now I can't get the subjects in order, there listed backwards (vol.7 comes before Vol.1 etc). Not the end of the world on this report but will be a real pain when I progress to Periodicals where the table of contents substitutes for the subjects in the media collection. The table of contents has to be in order by page number.
> How do I control the list order? I tried sorts on the IDsubject and the strSubject fields, No Joy.
> Walter
>
>
> --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> >
> >
> > I would expect the report to contain multiple records for the media table but don't understand why this is an issue. You can display the media fields in the media group header section. The detail section should resemble your previous subreport.
> >
> > I guess I'm not understanding what you can't do with a single report that you could do with a subreport (except you can now filter based on the media subjects).
> >
> > Duane Hookom
> > MS Access MVP
> >
> >
> >
> >
> > To: MS_Access_Professionals@yahoogroups.com
> > From: wgriffin48@
> > Date: Thu, 21 Jul 2011 16:11:42 +0000
> > Subject: Re: [MS_AccessPros] Searching on 2 tables
> >
> >
> >
> >
> >
> >
> >
> >
> > Duane:
> > I added the tblMediasubjects to the query that populates the parent report and all that does is create multiple records in the query for the same media item but with each having one of the subjects.
> > Maybe I could create a "subjectCollection" field in the query appending all of the subjects associated with a media item into a single string/memo field not displayed on the report to perform search functions on?
> > Walter
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> > >
> > >
> > > If there are multiple subject records related to one record in your main report, I still think this could be handled with a single report. You can set up group sections for Media and possibly other levels of detail. There would be no waste of space that I am aware of with a single report.
> > >
> > > If there are multiple types of "child" records such as Families with Children and Families with Trips, you would need a subreport for either Children or Trips. Another time a subreport is necessary is when you want multicolumn subreports.
> > >
> > > Duane Hookom
> > > MS Access MVP
> > >
> > >
> > >
> > >
> > > To: MS_Access_Professionals@yahoogroups.com
> > > From: wgriffin48@
> > > Date: Wed, 20 Jul 2011 23:49:44 +0000
> > > Subject: Re: [MS_AccessPros] Searching on 2 tables
> > >
> > >
> > > Duane; The subreport is populated from the second table containing all subjects for all media entries with each subject linked by a field containing the ID field in tblMedia to associate the subject entry to the correct media item.
> > > Since the number of subjects is unknown on each media entry this was the easiest way to create a "dynamic" report that expanded or contracted to fit the data onto the report and I didn't need to set up fields for "subject1, subject2, adnauseum" on the form/report and in the Media table and waste a lot of space on both the form/report/table involved. The data entry form is built the same way with a sub form for subject data.
> > > The parent reports data source is a query built from several tables, but I don't know haw to associate, what could be several subjects, that are records, in the tblMediaSubjects to a single record in tblMedia.
> > > It should be noted that the report works well otherwise and searches sorts on the other parameters (Or no parameters) and displays the data properly.
> > >
> > > Walter
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> > > >
> > > >
> > > > What is the justification for using a subreport. If there are only 2 tables involved, you should be able to use a record source from the 2 tables.
> > > >
> > > > Duane Hookom
> > > > MS Access MVP
> > > >
> > > >
> > > >
> > > >
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > From: wgriffin48@
> > > > Date: Wed, 20 Jul 2011 23:10:34 +0000
> > > > Subject: [MS_AccessPros] Searching on 2 tables
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Hello Group;
> > > > I've been missing a while due to surgery, but I'm up and banging away again.
> > > > I am trying to search on two tables at the same time, The search is to build a report. I have one table "tblMedia" in a library/collections application that contains fairly static information (IDMedia, title, producer, cost, value, etc) and a separate table "tblMediaSubjects" with (IDMediaSubject, idMediaLink(to IDMedia in tblMedia)and StrMediaSubject).
> > > >
> > > > The report is constructed with a report containing base information about the media item and a subreport containing subjects because the subjects may be numerous and the number unpredictable.
> > > >
> > > > One of the search parameters is a "like" search on strMediaSubject. I don't want the search to stop on the first hit as I want to display a report with all media with the target subject string.
> > > >
> > > > Is there a graceful way to accomplish this?
> > > >
> > > > John: You Can't retire! I'm still treading water here.. :-)
> > > >
> > > > Walter Griffin
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar