Help with filter

  • Thread starter Thread starter Rick C.
  • Start date Start date
R

Rick C.

Can someone suggest how I can display only those rows where the two
rightmost characters in Field1 are 'P1'? Thanks much.
 
Include a Where clause in your query similar to:

WHERE (((Right([MyTable]![MyField],2))="P1"));
 
The field referenced in the RIGHT function needs to be the field that has
the P1 in it....is KeyID that field?

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm



Rick C. said:
Thanks for this. I got the query to work once I got onto comfortable
turf, in SQL view, rather than the 'easy' graphical interface. I
originally thought a filter would work well, so in the Field row I
entered

Expr1: Right("keyid",2)

and then in the Criteria row I entered "P1"

It returns 0 rows, so I must be doing something wrong. Any hints would
be appreciated.


Include a Where clause in your query similar to:

WHERE (((Right([hsbosdb01_old]![keyid],2))="P1"));

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm



Rick C. said:
Can someone suggest how I can display only those rows where the two
rightmost characters in Field1 are 'P1'? Thanks much.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top