Question by  arunakumari (13)

How do you use len query in access?

I need to query different strings in access, the strings have nine characters in them.


Answer by  Jalaine11 (2043)

The best way to learn to use access is to read your users manual. You can also access the help section of your software. Both of these resources will walk you through the process of whatever you want to do. Often include are visual references so you will see these steps as you should see them on your screen.


Answer by  katherineagmailcom (140)

Len is used to query the length of characters or the number of bytes used to store data. The syntax for using is: Len(string | varname)


Answer by  japratt (1687)

To use this query in access you will need to be in database view at first. Once you are in this view you can use the query by clicking on the actual button.

You have 50 words left!