Access Reports with Multiple columns (not predefined)

[Balasubramaniam K]

I want to generate a report in ms access to show comparison of products, wherein there might be 2, 3, 4 ... vendors who submit quotations for any no. of products.

The products are displayed row-wise and the vendor names are to be given columnwise. Here the minimum columns are 2 and the max. limit can be anywhere between 2 to 7.

[puppydogbuddy]

What you want is well suited for a crosstab query. To create a crosstab query, do the following:
1. create a regular query that can be used as the "base query" record source for a crosstab query.
2. go to the query window and select the crosstab query wizard.
3. follow the wizard prompts and supply these answers:
a. for the data source of the crosstab, enter the name of your base query
b. for the column header, enter your Vendor field
c. for the Value column, enter your Quotation field
d. for the row header, enter your Product field
e. choose sum for Quotation
4. Keep in mind that the Crosstab wizard will not generate 100% of what is needed, but is a good starting point from which you can place the wizard generated crosstab into design view and refine it to your needs.
5. Once the crosstab is completed to your satisfaction, then go to the report window to create your report,using the crosstab query as the record source of your report.