Help with calculating age & displaying a date

[papabill]

I have the book "Microsoft Office Access 2007 Bible" and I'm trying to calculate age based upon the birthday of our members and the NOW() function. I have searched the book, but it makes little to no sense to me.

Also, I still haven't gotten a good grip on the way to display a date as "mm/dd".

Thanks

 

[GerryZ]

I have the book "Microsoft Office Access 2007 Bible" and I'm trying to calculate age based upon the birthday of our members and the NOW() function. I have searched the book, but it makes little to no sense to me.

Also, I still haven't gotten a good grip on the way to display a date as "mm/dd".

Thanks

You can try two diferent formulas!

Book1
	A	B	C
1	date of birth	today	Age
2	15/04/1968	18/04/2015	47
3	15/04/1968	18/04/2015	47
Foglio3

Cell Formulas
Range	Formula
B2	=TODAY()
B3	=TODAY()
C2	=DATEDIF(A2,B2,"y")
C3	=INT((B3-A3)/365)

 

[papabill]

Isn't that an Excel worksheet example? I'm working with an Access query

 

[GerryZ]

Isn't that an Excel worksheet example? I'm working with an Access query

Opsss! sorry i misread your post!

 

[alansidman]

Assuming two fields, ID, Birth Date in Table1

In a query

SELECT Table1.CustID, Table1.BDate, DateDiff("yyyy",[Bdate],Now()) AS Age
FROM Table1;

 

[papabill]

Assuming two fields, ID, Birth Date in Table1
In a query

SELECT Table1.CustID, Table1.BDate, DateDiff("yyyy",[Bdate],Now()) AS Age
FROM Table1;

Pardon what might be a dumb question, but exactly where does that go? I'm so new with Access I don't know where to put it.

 

[alansidman]

Open a new query. In the upper left corner you should see a drop down. Select SQL and paste this in. Open the query in datasheet view to see the results. Or open in design view and make sure that the table names and field names agree with what you have in your tables. I used your example. SQL language is what drives queries. In Access you can either do it in the QBE or write SQL directly.