Supplier's Price Comparison Print Output (1 Viewer)

Greetings!
I'm looking for a solution regarding this type of report (please see picture attachment). My data had been normalized already, the only problem is on how I am going to generate the report.
I tried pivot table but i could not insert the Terms and Warranty per Supplier as it could not be inserted on the values.
Is there any workaround in here? Thank you!

I have no idea really! However it did occur to me that you could put that separate information in a subreport?

Suggest you post your code as otherwise you're expecting us to guess blindly in the dark.

Better still post the relevant parts of your db

mikejaytlabustro,

One way to do this, which I really DON'T recommend, is to create sub-queries for each "Supplier". Said query would have
[ProductID]
[SupplierID]
[Ct_Quantity]
[Amt_Price]
[Amt_Amount] : [Ct_Quantity] * [ Amt_Price]

You would then create a query that is based on [ProductID] that would then join in the supplier queries.

Reason I really don't recommend this is because you are hard-coding in which suppliers you are reporting on. As you get more suppliers your report becomes increasingly more difficult to manage.

End result is you have a query that looks something like
[ProductID]
[ProductDesc]
[Qry_a].[Ct_Quantity]
[Qry_a].[Amt_Price]
[Qry_a].[Amt_Amt]
[Qry_b].[Ct_Quantity]
[Qry_b].[Amt_Price]
[Qry_b].[Amt_Amt]
[Qry_c].[Ct_Quantity]
[Qry_c].[Amt_Price]
[Qry_c].[Amt_Amt]


As you can see this becomes rather dreadful to maintain.

Uncle Gizmo said:

I have no idea really! However it did occur to me that you could put that separate information in a subreport?

Click to expand...

I try this one but not really satisfied with the result.
Item, price and amounts is on Pivot Table.
Note, warranty etc. is on the subform.

This is just a suppliers quote and the terms being compared.

ridders said:

Suggest you post your code as otherwise you're expecting us to guess blindly in the dark.

Better still post the relevant parts of your db

Click to expand...

This is just a suppliers quote and the terms being compared.

On the Suppliers_Quote_Header_Table fields are;
Supplier_ID
Note
Terms
Warranty
Delivery

On the Suppliers_Quote_Line_Table fields are;
Item
Price
Amount

Then i make some basic queries to come up with this output (please see attachment), but the preferred report is like on the excel sample. This could be easily done in excel but i find it quiet challenging to do in access.

mikejaytlabustro said:

This could be easily done in excel but i find it quiet challenging to do in access.

Click to expand...

Then I'll suggest you to export the data to Excel, then it is no easy way to do the setup you want in MS-Access.
The really hard part is how you want the report should look like, it is the horizontal part and the headlines that makes problem.
It can be done, but it requeries some VBA-skills.