Checking for last position in a Description column

  • Thread starter Thread starter RLN
  • Start date Start date
R

RLN

Using the QBE grid, is there a way to return all rows in a table where the
very last position in the DESCRIPTION column is numeric (zero thru 9) ?

I have tried several attempts at this and it is not working. Can this only
be done in VBA via an ADO recordset?

Thanks.
 
RLN said:
Using the QBE grid, is there a way to return all rows in a table where the
very last position in the DESCRIPTION column is numeric (zero thru 9) ?

I have tried several attempts at this and it is not working. Can this only
be done in VBA via an ADO recordset?


Set the description field's criteria to:

Like "*#"
 
Back
Top