The combo box I built does not automatically generating AfterUpdate code...as far as I've read, it should generate automatically when building it by...

Hi all, I have 3 tables (and forms) - tblFee6, tblFee61 & tblFee62. They all have the same fields - MinAmount & Fee. Each Fee field in each form has to have...

Hi i'm trying to create a query that calculates the age of a person. (in many of the cases the person is dead). I have a date of birth in one field and a date...

There are a number of ways of working out the age of a person, from the obvious: 'DateDiff("yyyy",,date())', to the rather more...

Hi all, I am designing a database for a photographer and for each client I have a table that will list family anniversaries (wedding, birthdays). For...

Hello All, I am needing help. I am wanting to enter a Date of Birth and know what age a person is on a certain date, let's say August 1st of the current year....

I succesfully run a query calculating members age from a birthdate field. The funny thing is that the query won't calculate properly people who was born before...

Access 2003 I am trying to calculate the age of a person directly in the query. Not sure it is possible but here is what I have tried that does not...

I am using an age calculation query in an Access database, but we are having problems. The age calculation seems to work well in Access XP or 2003, but any...

I need a formula to determine the age of an individual to be used for various calculations. The "age" is may not be the age of the person today, but as of a...

does anyone know how to look for over 60s using the DOB iv looked through some other queries and cant understand them, so make it as simple as possible...

I have one table that has field "Birthdate" I have another table with two fields Age of Retiree and Distribution Factor. I need to find the Distribution...

From the answer from the question I asked previous to this, I am required to get all the people aged between 18 and 24 from todays date. Again any help would...

I would like count the number of clients in my table that fall into the following age groups in my query or report. 62 and over, 51-61, 31-50, 18-30, 13-17,...

I need to update an AGEGROUP data field in a database based on an age. For instance if age 11 set agegroup to "10 and under", if age = or 12, set agegroup...

I would like count the number of clients in my table that fall into the following age groups in my query or report. 62 and over, 51-61, 31-50, 18-30, 13-17,...

I have an age field that is calculated from a birthdate. I want to count the number of records in age groups such as 10-19, 20-29, 30-39, 40-49. the...

Hello I know it's simple but my minds gone totally blank. I have a list of peoples DOB and from this I need to work out their ages. Any help would be...

I have a table with Date_Rec and Date_Awarded i would like the followig in days; Date_Rec-Date() Where Date_Awarded = "Null" Could someone assist?

Hi all Table = ChildEnroll field = Child_Date_Of _Birth How do I create a query or report showing how many children will turn 6 year old next 12 months...