Help :split 1 field data into 3 fields in same table

[eddii]

i have a table containing date

i want to split the data

field name : singledate
example : 12/Dec/2011

answer to be

1stdate 2nd date ( format date/time)
12 dec/2011

table view

singledate 1stdate 2nd date ( format date/time)
2/Dec/2011 12 dec/2011


is it possible

second question
and text field into 3 fileds

field name :alltext
Example :E02500X02

1st 2nd 3rd
E02 500 X02


table view

alltext 1st 2nd 3rd
E02500X02 E02 500 X02


is it possible in same table as

 

[John Big Booty]

I'm not entirely sure I understand exactly what it is you are trying to do. However I suspect that the DatePart() function is probably what you are looking for, if not perhaps one of the other date manipulation function will do what you are after. Whilst you are on the link also have a look at the String manipulation functions for the second part of your question.

 

[John Big Booty]

...as a general rule of thumb if you have a date, for example, stored in full, there is no need to store it in it's broken down form, as you can break the date down at any time, you need to display a portion of that date, using the DatePart() function.

 

[eddii]

thanks for reply : Help :split 1 field data into 3 fields in same table

thanks for reply
i want to split date as

ex: 12/dec/2011
to
day seperate and monthyear seperate
12 and dec/2011

because i want to compare the two dates whose month and year will be same but day will be different

like
12/dec/2011 compare with 15/dec/2011

and result to be same like it matches and return 1

 

[John Big Booty]

The DatePart() function should allow you to do that.

 

[plog]

Listen to John--the way you want to do this is not the correct way to accomplish this.

You should store that data in one field with a type of Date. Then use Access's date functions (http://www.techonthenet.com/access/functions/) to extract the various parts of the date when you need them in a query.

 

[eddii]

psl tell me how to use it in table design

because i want to compare the two dates whose month and year will be same but day will be different

like
12/dec/2011 compare with 15/dec/2011

and result to be same like it matches and return 1

 

[John Big Booty]

Tables are for storing your Data Only.

Reports are used for displaying your data.

Queries are used for collecting, and manipulating your data for display purposes, in either a Report or Form.

Forms allow your user to interact with your data.

You would therefore use The DatePart() function (or any other function) either in query or on a form, you would not use it directly in your tables.

 

[eddii]

thanks john i got it as iam still learning

thanks for patience and help