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
Rabu, 20 Juli 2011
[MS_AccessPros] Searching on 2 tables
__._,_.___
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar