Digit re-combination

V

viddom

Hi, I am new here, please be patient
In a query I have a field called MEMBERSHIPDATE with a format DD/MM/YYYY,
from it I want to generate, in anotyher column, a number with the following
format DDMMY. Please see examples for clarifing:
1/12/2005 I want to obtain 01125 (for the year I use the last digit)
8/2/2004 Iwant to obtain 08024 (for the year I use the last digit)
Please let me know what expresion can retreive such a number. Thanks
 
P

PC Datasheet

After you post once, please be patient and give us time to respond!!!

See your previous post.
 
M

Marshall Barton

viddom said:
Hi, I am new here, please be patient
In a query I have a field called MEMBERSHIPDATE with a format DD/MM/YYYY,
from it I want to generate, in anotyher column, a number with the following
format DDMMY. Please see examples for clarifing:
1/12/2005 I want to obtain 01125 (for the year I use the last digit)
8/2/2004 Iwant to obtain 08024 (for the year I use the last digit)
Please let me know what expresion can retreive such a number. Thanks
Click to expand...

Answered in a previous post with the same question.
 
Top