I have a school project where I have an access database with several tables. I am having great difficulty with two items 1) I have a lookup filed using the wizzare in table JOBS that looks up purchase date from the orders table and inserts it in jobs table. my problem is I am trying to add that to 5 days to make a delinquent date. I have tried = DateAdd("d",5, [PUR_ORDER] + 5 but it doesnt work. 2) my second problem is validation. I am trying to set a validation rule so that all the name fields are alphabetical but everything i tried to insert to the validation field errors. ie "alpha", >A<Z etc. If you have any ideas or samples of these I would really really appreciate them. thanks in advance
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
## Platform
win