Recent content by datamismatch

calculating someones age Yes I just found that out from doing a bit of reading. Tis a form that I new to display it in. Thanks for keeping an eye on me.

calculating someones age Thats working great, thanks for your help all I have to do now is work out how to feed it back into the table so I'll have a look through the forum I'm sure others will have had the same problem Thanks again, I really appreciate it.

displaying a date of birth Thank you so very much, that was exactly what I was looking for and the query is working well. Thanks again for all your tolerance and help.

Thanks again, I'm not explaining this very well... 1. I was using your suggestion as a criteria in the DOB column as you correctly guessed. I have now created it in a column of its own as you suggested and part of it is working - for example the display I now get for some whose DOB is 29/3/1925...

thanks for your help, two things 1. when I run the query I get a "data type mismatch in criteria expression", and 2. can I ask for all the records on a given date? Thanks

Thanks for that, I have a lot to learn, Really appreciate your help

Age=DateDiff("yyyy", [DOB], Now())+ _ Int( Format(now(), "mmdd") < Format( [DOB], "mmdd") )

The expression you entered contains invalid syntax. You omitted an operand or operator, you entered an invalid comma or character, or you entered text without surrounding it in quotation marks.

Thanks for that, I did actually find the link that you directed me to but I get a syntax error message when I run the query

I am using Access 97 In a table of members I have recorded a date of birth (DOB) displayed in the format 99/99/9999. Can someone tell me how I can calculate someones age from this field. Thanks

I must be dense the format 31 May would be fine Thanks for your help

Thanks, I need to get both the day and month together, the DOB field in the table is in the form 21/06/1996!

I am using Access 97. I have a table of a list of members each showing the date of birth for each one (DOB). I want to send a greeting to each on their birthday using a form and I need to develop a query showing the day and month for each one. How can I do this please?