This is more of a general question then a report specific one. I would almost call this a brainstorm rather than a question. Almost.
First to those who have been helping, as always thanks for all your help. I am taking a break from my crosstab report mess.
I am now thinking about the quote unquote final stage of my applications use, which is to cobble together all info previously entered into a nicely structured report (the quote our business would put out to our contractors) based on the users selection.
All reports/quotes would have their data populated via my table [tblProduct]. I have queries for each specific [VendorID] within the table to show my users each vendors quote that was imported broken down per vendor.
In a perfect world, my users would be able to pick and choose each individual item to put onto the report. I am thinking a check box would be the simplest method. So each product would have a checkbox to be able to pick it. I would probably also use a "master" checkbox to select everything within that vendors quote to choose all items.
So what would be the best method/approach to this? Use checkboxes then a query to copy the items to a temporary table specifically structured for the quote then base the report off that? That would keep the report consistent as far as structure, but would allow its contents to change.
If that would be the best method, how would I structure the query to manage that? The query would be run by a button click then open the report ideally. I dont think an append query is right, because I want to leave the data in the products table for later reporting purposes.
Thoughts? I am mostly just thinking out loud.
First to those who have been helping, as always thanks for all your help. I am taking a break from my crosstab report mess.
I am now thinking about the quote unquote final stage of my applications use, which is to cobble together all info previously entered into a nicely structured report (the quote our business would put out to our contractors) based on the users selection.
All reports/quotes would have their data populated via my table [tblProduct]. I have queries for each specific [VendorID] within the table to show my users each vendors quote that was imported broken down per vendor.
In a perfect world, my users would be able to pick and choose each individual item to put onto the report. I am thinking a check box would be the simplest method. So each product would have a checkbox to be able to pick it. I would probably also use a "master" checkbox to select everything within that vendors quote to choose all items.
So what would be the best method/approach to this? Use checkboxes then a query to copy the items to a temporary table specifically structured for the quote then base the report off that? That would keep the report consistent as far as structure, but would allow its contents to change.
If that would be the best method, how would I structure the query to manage that? The query would be run by a button click then open the report ideally. I dont think an append query is right, because I want to leave the data in the products table for later reporting purposes.
Thoughts? I am mostly just thinking out loud.