access course london - access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » access course london - Access

access course london - Access

resolvedResolved · Low Priority · Version Standard

Tina has attended:
Access Introduction course

Access

In a query criteria how do you pull back all records ending in a certain way when the field value can vary.

RE: Access

Hi Tina

Try the syntax
=RIGHT ([fieldname],#ofcharacters to return)


for example
=RIGHT([surname],4)

will return the last four characters of the SURNAME field

Regards

Richard


 

Access tip:

Hiding rows and columns

To hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column

View all Access hints and tips


Server loaded in 0.08 secs.