Edate

[Chris Warren]

I am using Office 200 Pro. I need to use EDATE in Access to calculate approximate birthdates, from an "application date" and an "age" (in years). I can get the EDATE function to work in Excel, but that is not much help as my dates are between 1780 and 1840. In Access I get the threatened "#NAME?" response. I have checked that msowcf.dll is installed on my computer (which is presumeably why it works in Excel).
Any advice on how to get it to work in Access would be much appreciated.
Thanks for your thoughts (and help with past queries)

 

[Chris Warren]

Birthdays

Thanks; I have managed to do it with DateAdd as you suggested.

However, being a novice in Access I'm not sure if it is possible to get to my objective. I can get this function to work on a FORM as=DateAdd("yyyy",-[Age],[ApplicationDate]) but I would really like to populate a field in an existing TABLE of individuals with these calculated dates, as one might in Excel. It's not possible to export the data to Excel, and do it there, as all of the dates are around the 1820s.

Is it possible to do it within Access?

 

[Rich]

You shouldn't store the calculated results, use a query to return them and export the query

 

[Chris Warren]

Sorry to be dense but I have also been unable to work out how to incorporate a function (apart from SUM) into a QUERY (as opposed to a FORM). I assume anything below the "Show" row is Boolean.
I tried a "make-table"query, but as I was not able to incorporate the function, I have an empty field!

My only option appears to be to calculate the data manually and insert it longhand, but with 500 records it would be a bit tedious. As the information is static (date of birth) it represents real data and it extremely frustrating to have to use a calculator 500 times, and type in the results one-by-one, with all this computing power facing me (allegedly).

On the subject of export, (assuming I had worked out how to do the calculation) the only option is as an RTF file as Excel won't accept the dates (before 1900). I found that out when I tried to export it into Excel so that I could use the EDATE function and then re-import it.

I would be very grateful for any further comments

 

[Chris Warren]

Pat,
Once again, many thanks for your help. It produced just what you predicted.
I have bought a 2-CD training course and fully interrogate "MS Help" before I fire off questions to this forum. Why is it all so difficult.
I don' t know how we would make progress without the support of you all.
Thanks