How to export a filtered list?

[L. D. James]

Can someone tell me how to export a filtered list (from a query) that
will only have the records that meets the criteria? If I have two hundred
names in a database, with only 10 living in Florida. I apply a filter that
will show just the 10 in Florida. However, any export (or save) I find will
always process the entire database (all the records in the base).

Thanks in advance for any suggestions on this matter.


-- L. James

 

[Rick Brandt]

Can someone tell me how to export a filtered list (from a query) that
will only have the records that meets the criteria? If I have two hundred
names in a database, with only 10 living in Florida. I apply a filter that
will show just the 10 in Florida. However, any export (or save) I find will
always process the entire database (all the records in the base).

Thanks in advance for any suggestions on this matter.

Modify the criteria of the query to filter the output. Filters are strictly a
GUI thing.

 

[Van T. Dinh]

Create a Query with criteria to select the Records you
want and then use that Query as the DataSource for your
export. The uery should be something like:

SELECT *
FROM [YourTable]
WHERE [PerState] = "Florida"

HTH
Van T. Dinh
MVP (Access)

 

[L. D. James]

Modify the criteria of the query to filter the output. Filters are strictly a
GUI thing.

Thanks for the quick response. I've been looking and testing every
thing I can see. It's eluding me on how to modify the output. I click on
export, but don't get options for this filtered (or modified output). Is
there something I can click on to see this option?

I save the filtered screen, but a sequent opening brings all the data
without the filter. The current option I was using to output was
File-->Export-->[File type] csv. This of course will save the whole base.

I guess the question in a nutshell is how to "Modify the criteria of
the query to filter the output"?

Thanks in advance for any follow-ups.

-- L. James

 

[Rick Brandt]

Modify the criteria of the query to filter the output. Filters are strictly a
GUI thing.

Thanks for the quick response. I've been looking and testing every
thing I can see. It's eluding me on how to modify the output. I click on
export, but don't get options for this filtered (or modified output). Is
there something I can click on to see this option?

I save the filtered screen, but a sequent opening brings all the data
without the filter. The current option I was using to output was
File-->Export-->[File type] csv. This of course will save the whole base.

I guess the question in a nutshell is how to "Modify the criteria of
the query to filter the output"?

Whatever the criteria is in your filter should be able to be applied as criteria
in the query. After applying your filter go to the advanced filter tool option.
That will display a query grid with your filter displayed in it. You just need
to apply that same criteria to the query. Then you should get the same output
without having to apply a filter.