Thanks for your help, Gary. But I'm still having some problems. The Artists and Comics tables were already in existence. I created a form and subform, and I am able ot filter the artist subform to get the results I want, but I can't get it to go into a report. I know I'm doing this the hard way. What I really want is to start a report that asks me which artist I want. I want to then select the artist's name from a pulldown. The report should show only those comics that have that artist's name in any of the artist fields from the Comics table. This is probably much simpler than it sounds, but Access has a real tendency to confuse me.
--- In [email protected], "Gary E. Daniels" <[EMAIL PROTECTED]> wrote: > > Oh! Oh! I know the answer to this one!!!!! You need to use a > SUBFORM!!!! I think this might give you what you need. > > 1. Make one table for just artists and any other info about each > artist. Include a field with a unique identification for each artist, an > Artist ID number. (Artist #1 could be "A-1", Artist #2 could be "A-2", etc.) > > 2. Make a second table just for comics and any other information about each > comic. Include a field to contain the Artist ID number found in the Artist > Table. > > 3. Create Queries for the searches and sorts you want. Select both tables > and create a relationship joined by the Artist Id. > > 4. Create a Forms(s) based on the Queriy(ies) you created. For each Form, > insert the "Subform/Subreport" (from the Toolbox - View, Toolbox), and > select the Comics Table. > > 5. For Reports, just create them based on the Queries you created. > > I think you should be on your way from here. Good luck. > > Gary > > > >Garry <[EMAIL PROTECTED]> wrote: > > I'm just now trying out Access. I've created a database for my comic > >collection. My main table includes fields for the artists. Since one > >comic may have more than one story, and several artists, I have > >separate fields for up to five artists per comic. > >I want to be able to run a report that shows all comics for one > >particular artist. I want to be able to choose which artist I want to > >run the report on. I want the report to show all work for that artist > >no matter which artist field (artist 1, artist 2, etc.) that his or > >her name shows up in for a particular comic. > >I'm having trouble figuring out how to do this. > >Can someone help? > >Thanks. > > > > > > > > > > > > > > > > > > SPONSORED LINKS > > Microsoft access database Database development > > software Database management software Database software Inventory > > database software Membership database software > > > >--------------------------------- > > YAHOO! GROUPS LINKS > > > > > > Visit your group "ms_access" on the web. > > > > To unsubscribe from this group, send an email to: > >[EMAIL PROTECTED] > > > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > > > >--------------------------------- > > > > > > > > > > > >[Non-text portions of this message have been removed] > > > > > > > >---------- > >YAHOO! GROUPS LINKS > > * Visit your group > > "<http://groups.yahoo.com/group/ms_access>ms_access" on the web. > > * > > * To unsubscribe from this group, send an email to: > > * > > <mailto:[EMAIL PROTECTED] subject=Unsubscribe>[EMAIL PROTECTED] > > > > * > > * Your use of Yahoo! Groups is subject to the > > <http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service. > > > > > > > >---------- > > Gary E. Daniels > Cornerstone Appraisal Company > 500 Selkirk Drive > Schaumburg, IL. 60194 > 847 882-5892 Fax 847 882-5963 > mailto:[EMAIL PROTECTED] > http://www.askdata.net > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
