Formulation Sheet Report Format Question

[Kozbot]

Hello,

The formulations for my company's products are contained in individual word documents. I want to enter this data into an Access DB and recreate the format of the formulation sheet as much as possible.

Each product has multiple raw material ingredients that each can have multiple options for that ingredient. Examples are attached. A product can have up to 8 ingredients and each ingredient can have have to 4-5 different options (from alternate suppliers, equivalent raw materials)

Is it possible to make an Access report look like one of the attached? The product information has a one to many relationship with the % formulation lines, which have a one to many relationship with the raw material options for that %.

Thank you!

 

[arnelgp]

dont you worry, Access can handle that.

 

[isladogs]

Yes it's certainly possible to create reports that look like that providing you use suitable queries for the data structure needed in each case

 

[Kozbot]

dont you worry, Access can handle that.

Is there a specific report format I'd need? I would need to sub reports? Potentially a sub report nestled in a sub report?

 

[arnelgp]

you don't need a subreport.
create an Aggregate (Total) query
as the Record source for the report.
the list of suppliers, we can use
the function ConcatRelated() (Mr.A.Browne).

 

[Kozbot]

Hello,

I have gotten to the format attached. It is almost what I want.

How do I get the raw material options to go horizontally across the page?

Thank you!

 

[arnelgp]

Is the row source from aggregate query?

 

[Kozbot]

Is the row source from aggregate query?

No. The aggregation is being done at the report level.