Access 2003 age query

[Jorgo]

In Access 2003 under Windows XP

I have made a database for the local Legacy group and they require reports on Widows of various ages.

I have their age calculated and shown in form view, however this number is not transfered back to the table. It is shown as 0.

As Query requires the age taken from the table I cannot get the Widows List for eg aged between 60 and 75

Is there any way of getting the age displayed in the table so that it can be used in the Query, or another way of getting the list for use in a Report

Jorgo

[missinglinq]

I'm not really sure exactly how you are set up, as you speak of tables and queries and forms, but not how they're realted in your database. Your form, even if based on only a single table, should really be based on a query based on the table! They are so many things you can do with queries that you can't do with tables. Making a table from a single table is as easy as using the Query Wizard.

Then in the Query Desing View, you can place a calculated field to give you the Widows' ages. In an empty field in the grid, in the name box type in:

 TrueAge: DateDiff("yyyy",[DOB],Date())-IIf(Format$(Date(),"mmdd")<Format$([DOB],"mmdd"),1,0)

where DOB is the field holding the date of birth. You can now base your form on this Query, as well as any Reports you need, using your new calculated field, TrueAge, just as you would any other field.

If you calculated an age in the form, and then stored it in a table field, the age stored would only be valid until the Widow's next bithday. If you calculate it in this manner, anytime you use the Query for a Form or Report the ages will always be up to date.

Welcome to TheScripts!

Linq ;0)>