Recent content by CrimsonLily

That worked PERFECTLY! THANKS!! I really appreicate it!

Thanks for the help, one more quick question: Where do I enter this code? Is it entered on the SQL view or somewhere else? Thanks again CrimsonLily

Please help! I need to know how to create a query that will tell me, when I give it a specific date, all the records that were created before that date. i.e. All the files dated before March 31, 2002. Any advice that you can give me would be greatly appreciated! Thanks again! CrimsonLily

Ok :) Thanks again Rudy & Coco, for all your help. I appreciate it greatly!!! CrimsonLily

Thanks for all the help! I really appreicate it. What should I change my regional settings to? Thanks for the addition to the code, I believe it did fix the problem.

The data type of the DOB field is date/time(short date). Would I be better off changing it to longer date? I changed the code and it still gives me those 2 negative numbers. It just doesn't make any sense. They are both under 30, and so are days of the month. Could it somehow be confusing...

The negative number that it's giving me are: 9/22/29 -27 4/8/27 -24 From what I've figured those number are exactly what the actual age is minus 100.

They are 4/8/27 & 9/22/29

Ok now I have a question about the results. A couple of the ages are showing up as negative numbers. Is there something I can do to remedy this? Thanks so much

That is so AWESOME!! THANKS so much!! I can be a bit dense sometimes. I appreciate your patience and your help greatly!!! Thanks Again CrimsonLily

I don't know a whole lot about Access so let me double check this code with you :) OK, so if my birth date column in my table is called DOB & my table is called People SELECT date(04/15/03) , thedate as birthdate , year(date()) - year(thedate) - iif(month(date())>month(DOB),0...

r937: do I add this code into Modules?

This is great. One more question: What would I need to do to this code so that it doesn't prompt me for a date. I just want it to figure all of the ages for all of the people in a column. Thanks so much for your help!! I've never had a response so quickly before :) CrimsonLily

Ok, I've got a database that lists people by date of birth. And for a project that I'm doing I need the actual age in years. Is there a query that will calculate a date of birth into an age in years?? Please help, I don't even know where to begin. Thanks!!! CrimsonLily

Thanks for all your help. I think I got it. I created a couple of macros to open the queries, then went to the switchboard manager and chose for it to run a macro. Thanks again for all your help :) Jen