I thought I had enough books but I guess not. In CLNG(MID what does the MID represent and are there others beside MID?
Frank FreeseAsked:
Who is Participating?
Missus Miss_SellaneusConnect With a Mentor Commented:

In Access, the Mid function extracts a substring from a string (starting at any position).

The syntax for the Mid function is:

    Mid ( text, start_position, number_of_characters )

Text is the string that you wish to extract from.

Start_position indicates the position in the string that you will begin extracting from. The first position in the string is 1.

Number_of_characters indicates the number of characters that you wish to extract. If you omit this parameter, the Mid function will return all characters after the start_position.
Rey Obrero (Capricorn1)Commented:
Mid goes with the gang of Left and right functions

clng converts the numeric string as Long numbers
Frank FreeseAuthor Commented:
Mid means???
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Missus Miss_SellaneusCommented:
Here's a great reference for all of the Access functions:
Rey Obrero (Capricorn1)Commented:
see this link too and use as reference
Frank FreeseAuthor Commented:
thanks...i thought it meant middle and now i understand
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.