Re: Calculating in table field

Tech-Archive recommends: Fix windows errors by optimizing your registry

I would guess you can mail merge from a query.



":(" <nomail@xxxxxxxxxx> wrote in message
news:uA6gfCfQFHA.4020@xxxxxxxxxxxxxxxxxxxxxxx
> ok ok Gotcha. Thanks.
> I only wanted it there coz I am trying to set up a mail merge into word
for
> a letter that will give the age of the person at the time of writing the
> letter.
> As far as I get it, you can only mail merge from tables and not forms.
> But that's another story. I promise to search more thoroughly before I ask
> about that one!!
> Thanks again.
>
>
> "Ed Warren" <eowarren@xxxxxxxxxxxxxxx> wrote in message
> news:em4hNueQFHA.2876@xxxxxxxxxxxxxxxxxxxxxxx
> > Don't store age in a table!!
> >
> > Date of Birth is a constant
> > Age is variable
> >
> > Use tables to store data (date of birth)
> > Use forms to 'see data' and enter data.
> >
> > Ed Warren
> >
> >
> > ":(" <nomail@xxxxxxxxxx> wrote in message
> > news:Om9S%23ieQFHA.132@xxxxxxxxxxxxxxxxxxxxxxx
> >> Hi.
> >> I've created a field in a form that calculates the age from the
birthdate
> >> of the previous field.
> >> But I would like it to figure in the table. All the help info only
tells
> >> you how to do it in a form.
> >> Can someone please tell me how to be able to do either have the table
see
> >> the age from the form or how to put the format in the table field.
> >> Thanks
> >> J.
> >>
> >>
> >
> >
>
>


.

Relevant Pages

  • Re: 16 generations across five and a half centuries
    ... guessing that some generations are probably missing. ... Grifith Bowen is alleged to descend from the famous Welsh ... having children at age 100. ... You count from birth to birth, ...
    (soc.genealogy.medieval)
  • Isabella Harwood b. c1860
    ... Age 41, place of birth Winlaton, Durham, England, current address 64 Walton ... Hannah Sinclair age 19,occ. ... William Sinclair, age 17, occ.Apprentice engine fitter, place of birth ...
    (soc.genealogy.britain)
  • Re: Change event trigger
    ... >change the Date of Birth field of the current record of form B. I ... I'd favor writing a function to compute a person's age and using ... Public Function AgeOfPersonInEvenYears(ByVal theBirthDate As Variant) As Variant ... Dim myAge As Variant ...
    (comp.databases.ms-access)
  • Re: how many generations?
    ... or 147,500 generations before homo sapien sapiens. ... birth, but the age averaged over all mothers and all births. ... whereby the ancient mother is still having children of her own [at age ...
    (talk.origins)
  • Re: [GEN-BENELUX] Sylvia Sarazijn uit het Groothertogdom Luxemburg
    ... Ze zijn in de 20er jaren verhuisd naar Ontario. ... Name: Octaaf L DE Wispelaere Gender: Male Age: 55 Death Date: 21 Aug 1979 ... Birth Country: Belgium Gender: Male Race/Nationality: Flemish Ship Name: Melita ...
    (soc.genealogy.benelux)