Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Changing Text to Data automatically

Posted on 2000-03-01
1
Medium Priority
?
167 Views
Last Modified: 2012-08-13
I have created a make table query , and within this query i have combined these three indivdidual fields cells days/month/years so that it is in one field cell.
The problem is this is in Text format and when run the make table query the date is still in text.
What i want to do is rather than having to manually change in the table design from text to date time format that i could do this automatically somehow via a macro or VB
0
Comment
Question by:job2cU
1 Comment
 
LVL 6

Accepted Solution

by:
simonbennett earned 210 total points
ID: 2573379
Lets say your source table has 3 fields

Day  Month  Year

Your make table query should have a column like:

FullDate: =cdate(trim([Day]) & "/" & trim([Month]) & "/" & trim([Year]))

Which sould give the follwing result

Data: "01"  "11"   "2000"
Result: #01/11/2000#

HTH

Simon
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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 …
Suggested Courses

782 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