Checking for last position in a Description column

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.
 
M

Marshall Barton

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?
Click to expand...


Set the description field's criteria to:

Like "*#"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

View jumps back to cursor position when scrolling in Word 2007 1
Finding Last Entry in a Column 3
Need VBA Macro to Loop through pages and print counter in footer of each page 9
Return to last position 8
Row and column count last occupied cells in range 2
Row position of specified column and value 12
create a formula to know last months column character or number 0
Find start position of the 9th occurance of a <character> in a str 2

Top