Filter

C

Cris

I have just made a table in access, but I have sime doubts.
I would like to know if there's a way of putting AutoFilter in the Table of
Access, the same We can put Autofilter in Excel, being able of filtering for
example, if I have a table based on Invoices, and if I want to see if any
Invoice has already came to me I just need to filter and chooce.
But in the table, not in Query, Form or Report.
Can Anyone help me?
 
B

Brendan Reynolds

While I would strongly recommend using forms, you can filter records in an
Access table. The methods used to filter and sort data in Access are,
however, quite different to those used in Excel. Check out the options on
the right-click shortcut menu in table datasheet view, and those available
on the Records menu on the main menu bar.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Top