A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

filter



 
 
Thread Tools Display Modes
  #1  
Old May 13th, 2010, 08:43 PM posted to microsoft.public.access.queries
Simon L
external usenet poster
 
Posts: 22
Default filter

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!
  #2  
Old May 13th, 2010, 09:37 PM posted to microsoft.public.access.queries
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default filter

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!

  #3  
Old May 13th, 2010, 10:06 PM posted to microsoft.public.access.queries
Simon L
external usenet poster
 
Posts: 22
Default filter

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!

  #4  
Old May 13th, 2010, 11:42 PM posted to microsoft.public.access.queries
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default filter

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!

  #5  
Old May 14th, 2010, 05:54 PM posted to microsoft.public.access.queries
Simon L
external usenet poster
 
Posts: 22
Default filter

Karl,
Thank you so much. It worked. I actually tried this before but got an error
message so I thought the query didn't work. If I looked more carefully I
would have noticed the two fields were formated differently. One was formated
for number and the other for text. After I reformatted one of the fields same
as the other. It worked. Thanks again for your help!

Simon

"KARL DEWEY" wrote:

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!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:41 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.