Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

clng(mid

Posted on 2008-10-03
6
Medium Priority
?
719 Views
Last Modified: 2010-04-21
I thought I had enough books but I guess not. In CLNG(MID what does the MID represent and are there others beside MID?
0
Comment
Question by:Frank Freese
  • 2
  • 2
  • 2
6 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22635577
Mid goes with the gang of Left and right functions

clng converts the numeric string as Long numbers
0
 

Author Comment

by:Frank Freese
ID: 22635602
Mid means???
0
 
LVL 12

Expert Comment

by:Missus Miss_Sellaneus
ID: 22635606
Here's a great reference for all of the Access functions:

http://www.techonthenet.com/access/functions/index.php
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 12

Accepted Solution

by:
Missus Miss_Sellaneus earned 2000 total points
ID: 22635610


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.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22635641
see this link too and use as reference

http://msdn.microsoft.com/en-us/library/05e63829.aspx
0
 

Author Closing Comment

by:Frank Freese
ID: 31502833
thanks...i thought it meant middle and now i understand
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question