That would be a part of a query SQL statement.
In design view the grid would look like this --
FIELD: Tier
TABLE: YourTableName
SORT:
CRITERIA: [S Tier]

While in design view you can take a look at the SQL by clicking on VIEW -
SQL View. It opens another window displaying the SQL.

--
Build a little, test a little.


"Simon L" wrote:

Karl,
Thanks for the response. I know it is just a simple expression like that but
I don't know where I can put this expression.

"KARL DEWEY" wrote:

WHERE [Tier] [S Tier]
--
Build a little, test a little.


"Simon L" wrote:

I have a database that have two fields: Tier and S Tier. There are different
values in these fields (e.g. Tier:1, 2, 3, 4... S Tier: 1, 2, 3, NC, DME...).
What I want is to only look at those records where Tier and S Tier are
different. In other words, if a record has "1" in both Tier and S Tier
fields, I want to filter that record out. Can you help?

Thanks!