Search results for query: *

looking for formula that could take two date fields subtract them and have how many days apart. and where to place them on possibly query or should it stay in a table and how where to create that table field. Thanks in advance.

Thanks repete. I also have found formula Rounddown(Now()-Dob)/365.25 will give whole numbers

Thanks THoey I am going to heed to your caution and try to add the formula to analyzed excell data before sending. Just an extra step.

Thanks for the response. Yes normaly I would not need to record age data however I am in need to convert those DOB to age to upload data to other depts for stats. They need to group ages for testing we perform

First my skills may be overstated. Tech/user might be my speed. I added a field to current database for age with a formula =(Now()-[client DOB])/365.25. with format to 0 decimal Works but will not enter data to table only shows on form.

First skills may be overstated Tech/user may be my speed. In Excell is there a (cell) formula to convert date 00/00/000 to numerical age 00 years old

thanks wwgmr I will explore.That would mean I would have to establish the form as a subform and under properties select not to have visiable then command to show subform?

have subform with 3 link fields to main form. would like to have a command button show subfrom when needed. tried command button to open form and control source link to those fields but would not enter said link fields into table subform is related to.

Would like to know if there is a way to have a command button on a (multi Table ) one form that will print a report of current data that was entered. I currently have a command to open report run off a query with parameter value windows. That too many steps would like simplify it.