greater than '*p' 2

[acent]

I have a report that prints out PO shippers with the following where clause:

WHERE (((po.poNumber) Like '*P' Or (po.poNumber) Like '*Q') AND ((po.trackingNo)=" & Globals.trackingNo & "));

All works well, except in the extreme case more than 2 POs for that one job. My question is, is it possible to change the above to something like:

WHERE (((po.poNumber) Like > '*O') AND ((po.trackingNo)=" & Globals.trackingNo & "));

to print out any POs with a P, Q, R, S..., or is there a better way to go about something like this?

Anwy help is appreciated.

"God is a comedian playing to an audience too afraid to laugh."
-- Francois Marie Arouet (Voltaire)

 

[Remou]

Perhaps you can use Right?
WHERE Right([poNumber],1) >= 'O'

 

[Golom]

or

WHERE po.poNumber Like "[P-Z]*"