Re: [LegacyUG] Age at time of event and sentence definitions

2009-03-09 Thread RICHARD SCHULTHIES
Seems like a reasonable add-in. The age 'at an Event' is found in Chronology reports, but may not carry well. Rich in LA CA --- On Mon, 3/9/09, Christine Pearce wrote: > From: Christine Pearce > Subject: [LegacyUG] Age at time of event and sentence definitions >

Re: [LegacyUG] Age at time of event and sentence definitions

2009-03-09 Thread Dennis M . Kowallek
Thinking about it some more... If you aren't using the Description field, you could probably write a custom function (in VB) that you could call to populate tblER.Description with the age at the time of the event. All this would be done in MS Access. Then you could use [Desc] in your event sentenc

Re: [LegacyUG] Age at time of event and sentence definitions

2009-03-09 Thread Dennis M . Kowallek
On Mon, 9 Mar 2009 15:48:25 -, "Christine Pearce" wrote: >I'm really keen to have age in events and, since Legacy is an Access >table/dB, wonder if I could create a new Select Query in the database > >I'd add a new column with (for example) > AgeAtEvent:=DateDiff("",[Birthdate],[EventDa

Re: [LegacyUG] Age at time of event and sentence definitions

2009-03-09 Thread Randolph Clark
Not sure I understand. If the year is entered then the age is in the Chronology. Do you want to enter (example) 18 for the age at time of marriage? On Mon, Mar 9, 2009 at 11:48 AM, Christine Pearce < christ...@great-chishill.demon.co.uk> wrote: > Perhaps I'm mistaken, but it appears there isn't m

[LegacyUG] Age at time of event and sentence definitions

2009-03-09 Thread Christine Pearce
Perhaps I'm mistaken, but it appears there isn't much interest in the ability to add a person's age at the time of any given event, and therefore may not be in a new release. I'm really keen to have age in events and, since Legacy is an Access table/dB, wonder if I could create a new Select Query