Tampa Bay Business Daily

In Access, how do you control data source for a report using buttons?

I have a single report I would like to use. The table is structured with several columns. Is there a way to have multiple buttons on a form, and configure each button to open the report using a different data source (different column). So button 1 would be a report using column 1, and button 2 is for a report for column 2, and so on.

Public Comments

1. Yes.. But I'd probably simply copy the report and configure each for each column.
2. many ways easiest would probably be make a query for each column ie query 1 "select column1 From Table" query2 "Select column2 From Table" etcc then create a button with an onlcick event to open the query or report using the query