Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CasVan

    Calculating Age – Accounting for missing DOB’s

    MichaelRed - Thanks for the heads up on the redundancies featured in my query. I will try to streamline my query and keep the group updated on my issues... progress. Thanks Again ~Cas
  2. CasVan

    Calculating Age – Accounting for missing DOB’s

    All - This ia a variation of the “Isolation of problem with calculating age” post by MADDPM of 13-Nov-2008 I would like to account for individuals without DOBs with either a null value and/or a dummy date of 00/00/0000. Right now, if the qryDates runs, the fields with the missing dates...
  3. CasVan

    Isolation of problem with calculating age

    Remou/MichaelRed - Thanks for the quick response. This is a great code.. I am using it in the genealogy database I am slowly building. Due to the nature of history I find I have a need input various DOB,DOD dates into the system by record type. So I was quite HAPPY to find a module that...
  4. CasVan

    Isolation of problem with calculating age

    Thanks PH.. For answering, I actually posted the qoute without the extra ) by accident. I have the correct version in my database. But the question still stands.. Is it something easy as adding an Nz or isnull to the following? in order to produce a blank field if the DOB field is empty...
  5. CasVan

    Isolation of problem with calculating age

    This code has been of great help. I would like to get rid of the #Error code which is being produced by empty DOB fields. If there is no birthdate the field should be blank. Is it something easy as adding an Nz or isnull to the following? =basDOB2AgeExt([DOB],Nz([DOD],-1) Any Ideas? ~Cas

Part and Inventory Search

Back
Top