Help with filter

[Rick C.]

Can someone suggest how I can display only those rows where the two
rightmost characters in Field1 are 'P1'? Thanks much.

 

[Kevin @ 3NF]

Include a Where clause in your query similar to:

WHERE (((Right([MyTable]![MyField],2))="P1"));

 

[Kevin @ 3NF]

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

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

Can someone suggest how I can display only those rows where the two
rightmost characters in Field1 are 'P1'? Thanks much.