Make table query from filtered table

[Cujo67Camaro]

I have come across a snag in my access project I am currently undertaking and need some advise on what should be done next. . .

In a nutshell, this project's primary purpose is to perform a search on a table of information based on many fields and generate a report based on the records which match the search. I have the search form working (similar to this one here) http://allenbrowne.com/ser-62.html

It displays the results from the table based on the search criteria. The form is great for viewing the results which match search criteria; however, I am having trouble doing anything else with the data (perform operations on the data, send the results to the table, etc. . .). How should I go about moving this data to a table?

 

[hmongie]

Just an idea,


you would probably want to use the reports through access. Run through the wizards and it should guide you through the step on how to create a report. In your reports, you can use filterings/queries that you had created also, to only select records that you would like to see.

Try out summing up the fields or counting the records and etc. I think this is where you should be headed.

The form query that you had mentioned about really only shows a form layout of filtered records. For more dynamic report appearance, use a report.

hope that gives you some ideas.

 

[Cujo67Camaro]

Thanks!

The reason I want to create a new table with the filtered information is because I would like to be able to create a few different reports based on the filtered table information. For example I would like the report to individually list cases that meet the search criteria or a report which displays summary information (i.e. total amount or number of individual cases). The functions on the data may be more complex than that which is why I need it in a separate table. Because there are several different reports possible for this project I thought it would be best to dump that data into a table which gets renewed each time a search is performed. That way it would be easier for me to refer to in my code or queries. (Plus, being a novice in Access that was the only way I could figure out to do it). If there is an easier way, I don't really know how to refer to the filtered data.

 

[boblarson]

If there is an easier way, I don't really know how to refer to the filtered data.

Unless you have data which takes a long time to run a query on, a make table query is not needed as you can use the query just like it was a table. So, create a query to pull the data you want and then just use it just like you would a table.