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 Chris Miller 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. TheElkster

    Showing a Calculated field from a Query in a separate Form

    Wait up.... I had a MS Security Alert box up - after I clicked "Enable this content" - it changed from -1 to the correct age! Thanks again. ;)
  2. TheElkster

    Showing a Calculated field from a Query in a separate Form

    Hi Ace Man I swapped my code for yours.... and whereas I got the correct age with the code I was using - your one gave me an age of -1 ???
  3. TheElkster

    Showing a Calculated field from a Query in a separate Form

    I got it to work! Instead of having a separate query to work out the ages, I added a text box to the form and typed the following into the Control Source for that box: =Int(DateDiff("d",[DOB],Now())/365.25) now each record shows the correct age for that person. Thanks Paul
  4. TheElkster

    Showing a Calculated field from a Query in a separate Form

    Hi I like using Access 2007 but am a novice. ============================================================= Scenario: I want to show the age of each person in my database on a form ============================================================== I have a table that holds a list of people and...

Part and Inventory Search

Back
Top