B
bluesky
I am designing a database of products, probably about 350 different products
total. There are several different main groups of products, and within that
subclasses. I have created the main database, where I would enter a product,
and specify what group and subgroup. In addition, there are about 40 or 50
other fields/columns with different information about the product. However,
for each group of products, I only use certain fields, because I want to
display certain information. That means that I don't need all the other
fields. But I have all of the fields there, in one database, to make it easy.
But here is my problem: When I am trying to create a report, not only would
all of the fields fit on one page, but it doesn't make sense to display
fields that aren't used for a particular group of products. Basically I am
wondering if there is a way to create a report where what is displayed on
the page is specific for one particular product group. For example, let's say
that I have 5 classes of products: Class A, Class B, C, D, and E. Then, let's
say that, in the master database, there are 20 different fields/columns,
1-20. Let's say hypothetically that one field displays the size of the
product, one displays the color, etc.--all with different information.
Let's say that for Class A products, I only use fields 3, 4, 8, 7, 11 and
20. So, when I make the report, I only want those headings to be displayed
for those products. For Class B products, however, I may only use fields 2,
9, and 5; hence, I only want at information to be displayed on the report.
Access is set up so that there is only one consistent way of organizing all
of the information. But how can I make it different for different parts of
the report? Is there a way to do this? Or do I need to create separate
reports for each class of products, and then one master report from all of
those subreports? Or do I need to create one separate database for each class
of products, and then make a subreport for each and then one master report?
I hope I didn't make it too convoluted. ANY advice/pointers would be greatly
helpful, and if it doesn't make sense I could try to clarify it more. Thank
you!
total. There are several different main groups of products, and within that
subclasses. I have created the main database, where I would enter a product,
and specify what group and subgroup. In addition, there are about 40 or 50
other fields/columns with different information about the product. However,
for each group of products, I only use certain fields, because I want to
display certain information. That means that I don't need all the other
fields. But I have all of the fields there, in one database, to make it easy.
But here is my problem: When I am trying to create a report, not only would
all of the fields fit on one page, but it doesn't make sense to display
fields that aren't used for a particular group of products. Basically I am
wondering if there is a way to create a report where what is displayed on
the page is specific for one particular product group. For example, let's say
that I have 5 classes of products: Class A, Class B, C, D, and E. Then, let's
say that, in the master database, there are 20 different fields/columns,
1-20. Let's say hypothetically that one field displays the size of the
product, one displays the color, etc.--all with different information.
Let's say that for Class A products, I only use fields 3, 4, 8, 7, 11 and
20. So, when I make the report, I only want those headings to be displayed
for those products. For Class B products, however, I may only use fields 2,
9, and 5; hence, I only want at information to be displayed on the report.
Access is set up so that there is only one consistent way of organizing all
of the information. But how can I make it different for different parts of
the report? Is there a way to do this? Or do I need to create separate
reports for each class of products, and then one master report from all of
those subreports? Or do I need to create one separate database for each class
of products, and then make a subreport for each and then one master report?
I hope I didn't make it too convoluted. ANY advice/pointers would be greatly
helpful, and if it doesn't make sense I could try to clarify it more. Thank
you!