Hi Garry,
There are a few things that you need to try and figure out.
1. First, you need to brush up on a process call normalization.
Normalization basically is breaking down your database into various tables such
that the best performance can come from it. In your case, you can probably
have a few table set up as such:
a. One table for the artists, one for the comic books, one for stories.
You can link all of these table by a primary and foreign key such that your
database is not only efficient but can get your information easily through
queries. You can them create reports off of the queries pretty easily.
I hope this helps. Off the top of my head, the only book that I can think of
that explains normalization in a fairly easy way is in Access 2003 Bilble or
Access 2000 Bible.
Jose
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
<*> 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/
