Search results

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:confused:. I don' t know how we would make progress without the support of...

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...

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...

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...

Thanks again. Its a pity though, as there is a 1 in 365 chance that it could be a real date as opposed to an "artificial" day/month (I've actually tried 1 Jun as it's halfway through the year and therefore bound to be within 6 months of the "truth"). Would it be good practice add an extra field...

Thanks for the suggestions. It works just fine, sorting things into chronological order. However, operating with real data brings me on to another problem. I know some dates precisely ( eg 22 December 1827) such as those obtained from dated letters, but others I only know to the nearest year...

Thanks for your incredibly quick reply. I had tried it as a query but I was too green to spot the sort function. It worked straight away. Thanks for helping me to move on to the next stage.

My research covers the years between 1780 and 1860. Does anyone know I can set up Access to manipulate dates in this period (and in a format something like dd/Month/yyyy). Thanks

As a novice, this may be a stupid question. If so I apologise. My problem concerns the order in which data appears in a combo box. This concerns two tables, Artist’s Names [artistID; name; date of birth;etc] and Addresses [addressID; street; number; area; city]. Because each artist lived at...