Filters

[preveo]

Hi,



Can some-one please tell me why I can put filters on certain fields in a form and not others.

As you can see from the attached screengrabs I can put a filter on First name, but not surname.

All the settings I can see for the fields are exactly the same in the table.

Any help really appreciated.

[JoeM]

I believe Access will only filter up to 1000 different values.
So if there are more than 1000 different values in the Last Name field, you probably won't have the option to Filter by it.
You will probably need to resort to doing a query instead.

[preveo]

Hi,

That might be the case with the names, but I am also trying to filter on fields which have way less than 1000 records.

Attached is a screengrab of me trying to filter on the field done business. Nothing comes up, even though there's only about 100 companies which I've done business with. And this is the same across all the fields. How come?

[preveo]

And if I create a form on a query I can filter fine on these fields which have less than 1000 different records, so how come I can't filter on the data from a form on a table?