L
LeBaron via AccessMonster.com
I have created 2 tables, a Day table and Month table. I have two fields in
both, Day table has Day, Text; Month table has Month, Text. I have a query
combining the two so the query has Day, Days_Text, Month, Months_Text. What
i wanted to do on one of my forms is have a date field using the short date
so i can have the numeric value of course, is if the day of the month format
is 'dd' or 'mm' it would look into either the table or query and bring back
the text value, same for the month. Example: day '11', would read
'Eleventh', and month '09' would read 'Nineth'. The text value is in the
tables i created already. Where and how would i do this? This is for the
Reports using a Date field from my client Table. This is the only thing i
have left to do with my database i created for my boss.
both, Day table has Day, Text; Month table has Month, Text. I have a query
combining the two so the query has Day, Days_Text, Month, Months_Text. What
i wanted to do on one of my forms is have a date field using the short date
so i can have the numeric value of course, is if the day of the month format
is 'dd' or 'mm' it would look into either the table or query and bring back
the text value, same for the month. Example: day '11', would read
'Eleventh', and month '09' would read 'Nineth'. The text value is in the
tables i created already. Where and how would i do this? This is for the
Reports using a Date field from my client Table. This is the only thing i
have left to do with my database i created for my boss.