Rabu, 20 Juli 2011

[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

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar