Solved

clng(mid

Posted on 2008-10-03
6
699 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 11

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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 11

Accepted Solution

by:
Missus Miss_Sellaneus earned 500 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

861 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