[AccessD] Filters in Datasheet View

[David Emerson]

Thanks for the reply Charlotte.

Am I confusing the built in filters with Excel?  I thought I had seen them
in Access.

Regards

David

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Charlotte Foust
Sent: Thursday, 20 September 2018 8:05 p.m.
To: Access Developers discussion and problem
Subject: Re: [AccessD] Filters in Datasheet View

You have to use a query for that.  It is outside the capabilities of a
filter.

On Wed, Sep 19, 2018, 7:22 PM David Emerson <newsgrps at dalyn.co.nz> wrote:

> Hi Listers,
>
> Access 2010.  Access table back end.
>
> I have a datasheet view of a form which shows the sort and filter dropdown
> in the column headings.  I see the sort options, and standard filters (eg
> Text filters for Equals, Does Not Equal, etc).  However, I don't see in
the
> list the options to select several items.  EG a countries field should
have
> a list of the countries in the data so that I can filter several at the
> same
> time by checking boxes.
>
> I have simplified the data source so that it is only 1 table.
>
> I have the same problem if I open any table directly.
>
> Is there a setting or condition that has turned this off?
>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand