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]>[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/
