Hi All. My name is Buster and for my sins I have had to learn access basics rapidly as we are moving databases from the creaking old Paradox to access.I have done all the basic stuff, created necessary tables, relationships and data entry forms and still using Crystal Reports as it looks easier and has great functionality than access reports (I think).
I am now getting to some little problems that I can't seem to get round. The one right now is that I want to calculate age from date of birth on a form. This I can do and have done. However I now want to convert this calculated value into a fixed integer and enter it as a field in the form's associated table. The idea being that this will show the age of the person when they were captured into the system, so it will remain a fixed value in the table. Any ideas?.
I am now getting to some little problems that I can't seem to get round. The one right now is that I want to calculate age from date of birth on a form. This I can do and have done. However I now want to convert this calculated value into a fixed integer and enter it as a field in the form's associated table. The idea being that this will show the age of the person when they were captured into the system, so it will remain a fixed value in the table. Any ideas?.