i need some help with field properties in a table , for a college assignment and i'm new to access , so please help me T_T with those :
1.making the last letter capital(uppercase) and the rest not(lower case) and limit to 15 character .
2.the date should be between 1/1/2012 and 31/12/2012 .
3.first letter capital and the rest not .
4.a ten character string that contain any 3 character followed by one zero and six digit , like this (USA0344543)
5. 10 character beginning with Z and uppercase with blue color
6.price must be either 10.000$ or greater than 999.9999$
i searched almost every corner of net and didn't find anything :banghead:
please any help would be appreciated T_T
1.making the last letter capital(uppercase) and the rest not(lower case) and limit to 15 character .
2.the date should be between 1/1/2012 and 31/12/2012 .
3.first letter capital and the rest not .
4.a ten character string that contain any 3 character followed by one zero and six digit , like this (USA0344543)
5. 10 character beginning with Z and uppercase with blue color
6.price must be either 10.000$ or greater than 999.9999$
i searched almost every corner of net and didn't find anything :banghead:
please any help would be appreciated T_T
Last edited:
