Hmmmmm! I'll have to get back to you on this. I made a similar database, but didn't create a report, just forms. Let me tinker a while to see if I can be of further help.
Gary At 10:36 PM 3/17/2006 +0000, you wrote: >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>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/>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>http://www.askdata.net > > > > > > > > > >SPONSORED LINKS ><http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+databa>Microsoft > >access database ><http://groups.yahoo.com/gads?t=ms&k=Database+development+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+da>Database > >development software ><http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+dat>Database > >management software ><http://groups.yahoo.com/gads?t=ms&k=Database+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+softw>Database > >software ><http://groups.yahoo.com/gads?t=ms&k=Inventory+database+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+data>Inventory > >database software ><http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+dat>Membership > >database software > > >---------- >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. > > > >---------- 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/
