Hi all,

I would like to save the data generated from my query as a table. This will then allow me to report on that data much quicker as well as allow for me to share that specific data so that it can be used within another database.

I know you can save the query but this this means the data can only be used on that database. Whereas if I could save the date from the query as a table that would allow for much more flexibility.

Regards. Pari.

simple - use a MAKETABLE query

Change the query to a make table query and then press the Run button

I would use it to make a table in the first instance. Then I would make the necessary changes to the field properties of the table. One prime example is that Access tends to make text fields 255 characters wide. Then I would set up the indexes, if needed. Once that has been done I would copy the structure to a Side Front end mdb. Link it then use delete and append queries to populate the table.

This cuts down the bloating of the front or back end unnessessarily. Then as you say use this as the basis of your report. If other people need access to this table you can simply send them the mdb as and when required without having to export it each time.