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.In Access, how do you control data source for a report using buttons?
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 queryIn Access, how do you control data source for a report using buttons?
Yes.. But I'd probably simply copy the report and configure each for each column.

makeup help