Help on a filter form/query

[trekwars2000]

Lets say I have a table with 10 rows and columns of data.

I have a form with 10 check boxes (to represent all the columns of data). Each check box that is selected will be filtered out of the original table and displayed in a new table to be outputted for printing. There is a "DONE" command button on the form and this will be used to run the make-table query.

How do I make the query to do this? It doesn't seem that hard, but as a beginner at Access I am having some problems with it. When a check box is clicked I want to use that as the "trigger" for the data that will be in the new make-table.

Thanks for the help. Perhaps I am looking at this the wrong way????

 

[GingerR]

Hi. It would probably be easier for us if you provide some sample data, what the user would be selecting, and what you want the output to look like. I think there are some semantics problems: a "column" is the vertical "field" of data. So the users will be choosing which "fields" to report on? I just want to be clear. It's hard because you said it's 10 rows and 10 columns, so I can't distinguish what the 10 check boxes pertain to.

Also, yes you are thinking wrong. You don't re-save data into another table. It's bad db design to save the same data in more than one table. Instead you design a report, query or form that displays the data from one table.

Please try explaining more, with sample data and output.

Thanks.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[trekwars2000]

More specifically it is going to be used to select multiple time zones (-12Zulu, -11Zulu....Zulu, +1Zulu...+12Zulu, etc.) and then use the "DONE" button on the form to output a table with the values of all the data in the fields (each field being a time zone) that are selected.

For instance, if I want EST, GMT, and Guam (-5Zulu, Zulu, +10Zulu) I would select thoes boxes and click the done button which would then run a make-table query to output the results in that table, that way the user could see the times in each time zone (say 1 AM EST, 6AM Zulu, 4PM Guam).

Each field has the Time Zones as the field heading and 24 entried (one per hour) so an easy comparision can be made when the selected fields are outputted for printing.

I hope this make more sense.

Thanks

 

[GingerR]

Hi--again, it would be a lot easier for us to help you if you provided your table structure and sample data as opposed to "for instance" paragraphs.

Also, again, you would make a QUERY to show the user the result, not write the same data into another table.

It sounds like your table structure is not normalized. Again, please diagram out your table structure. And please see the links in my signature for more help on the basics.

Ginger

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html