Column filtering in DataSheet in Microsoft Access 2010 with joined tables does not work

I have an access form with a Record Source that pulls information from two tables

Select Rate.Prefix , Rate.Name, Provider.Carrier, Provider.Dest type,

from Rate

inner join Provider

on Rate.id = Provider.rateid

now when i a generate a datasheet form, with the above four columns. Prefix and Name will do filtering, but Carrier and Dest type will not do 开发者_开发技巧any filtering.

The project is an Access Project file(.adp), that links directly to sql database tables.

refer the images below

Filtering using the Name Column

After Filtering the data looks like in the screen below

Now the screen below shows trying to filter using Carrier Column (this is before Filtering)

Now after filtering, the data still remains the same as shown below

Anyone with ideas if datasheet do not support filtering, on joined table columns?