Manipulating dates

[Denis]

I have a date field in a database. I have been given forms to be
printed out.
The problem is that the form requires the date to be printed out in 3
seperate parts. In the form day month and year.
All numberic with the year in the form of 07 06 05 etc instead of
2007
2006 2005 etc.

Another issue this form has brought is that I have a membership
number
field as an 8 digit string.
The form requires the number to be printed one charachter per box so
I
need to split the string.
Is the above possible and how would I go about it.
Thanks
Denis

[ruralguy via AccessMonster.com]

Look into the Format() function to print any part of a date in almost any
format you might want. The Mid() function can pull a string apart for you.

Denis wrote:

>I have a date field in a database. I have been given forms to be
printed out.
The problem is that the form requires the date to be printed out in 3
seperate parts. In the form day month and year.
All numberic with the year in the form of 07 06 05 etc instead of
2007
2006 2005 etc.

Another issue this form has brought is that I have a membership
number
field as an 8 digit string.
The form requires the number to be printed one charachter per box so
I
need to split the string.

Is the above possible and how would I go about it.

Thanks

Denis

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200709/1