Access...Is it true that the difference between querie and filters is that results of filters cant b stored?

0 ⤊

Access...Is it true that the difference between querie and filters is that results of filters cant b stored?

2006-08-02 17:00:29 · 3 answers · asked by Inconsolable... 1 in Computers & Internet ➔ Software

3 answers

yes right

2006-08-02 17:04:24 · answer #1 · answered by Anonymous · 0⤊ 0⤋

Neither Filter nor Query has the ability to store the results. Access converts your queries into SQL Statements and only saves that statement. Filter is part of query and it also gets saved part of SQL Statement's WHERE Clause. So both Filter and Query doesnt store the results.

2006-08-03 06:29:52 · answer #2 · answered by Indian_Male 4 · 0⤊ 0⤋

Yes, filter is like a quick tool to search some records, or to test a condition. When you want to document these rules and want to use them again and again you can write a query, and use it when ever you need.

2006-08-03 00:08:46 · answer #3 · answered by Happy Smile 1 · 0⤊ 0⤋