473,503 Members | 1,650 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

what is the equivalent function of CAST in MS Access?

1 New Member
How can I convert my query in MS Access to change date to varchar?

Expand|Select|Wrap|Line Numbers
  1. (SELECT
  2.         LEFT([TIME],10) AS [DATE],
  3.         CAST(LEFT(RIGHT([Time],12),2) AS VARCHAR) AS [TIME],
  4.         COUNT(FORMAT(LEFT(RIGHT([Time],12),2) AS INT)) AS [Number of Calls],
  5.         RIGHT([CNumber],10) AS [CNum]
  6.     FROM 
  7.         [ABC#csv]
This is just a part of my long query.
Jan 24 '14 #1
1 26724
Seth Schrock
2,965 Recognized Expert Specialist
MS Access doesn't have a data type VARCHAR. The CStr() function changes the data type to a string and the Format() function returns a string. Here is a link with more information about the CStr() Function and the Format() Function.
Jan 24 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

10
1681
by: Brad Tilley | last post by:
Is there an easier way to do this: def print_whats_returned(function): print function print type(function)
0
1875
by: Jon | last post by:
I use the following function in Oracle SELEC T decode(status,'A','Active','L','Active','Former') FROM Table What it means is: if status = A, return "Active", if status=L, return "Active", else...
1
1514
by: Dave | last post by:
I have used the 'Date()' function in Access on several occasions to insert the current date into a field. However, I notice that on some computers, the macro fails, saying it doesn't understand teh...
4
3866
by: tdick | last post by:
Does anyone know sql of the PV function in Access? (same function in Excel) In access the inputs are PV («rate», «nper», «pmt», «fv», «due») where rate = discount rate, nper = number of...
1
6477
by: Jaime Leivers | last post by:
Here's a median function in access that you can call in any query. You could change this to any excel function you wanted. Most people can find the windows help file that says how to call an excel...
1
6482
by: neelz | last post by:
Hi Friends, I am porting an application from Linux to Windows. In the source code, <sys/times.h>, time.h etc. header files are included and tms structure, times() function are getting used. I have...
7
4391
by: =?UTF-8?B?QW50w7NuaW8gTWFycXVlcw==?= | last post by:
Hi, Sorry if this's been discussed before, I couldn't find it. As well you know, the ECMAScript standard doesn't include any way to access a function's caller. This has been available on Mozilla...
1
4617
by: seanmatthewwalsh | last post by:
Hi I have a website that uses an Access 2003 database. I have controls on my pages that are bound to SqlDataSources that pull data from this database. In a couple of them, I need to use the...
1
2290
by: Pankaj K Joshi | last post by:
Sir I have Excel function of converting figure into words, now I want to use this function in access. Now how to use it in access? I have two text box in access one is of Amount & other is of...
4
8536
by: kkshansid | last post by:
Kindly help me how to write and call VBA function in access I want to print simple hi function with VBA programming VBA function is not working correctly and asks for parameter value and after...
0
7201
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7083
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7278
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
6988
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5578
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4672
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3153
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1510
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
734
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.