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 SkipVought 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: *

  • Users: CinS
  • Order by date
  1. CinS

    Get Age from BirthDate field in a Query

    Thank you for the code. Evidently I have the data type messed up for the [BirthDate] field. I originally had it as text because I imported it from a .txt file and it wouldn't convert dates. Your code didn't work with it, came up with "#Error" in the Age field when I run it . I...
  2. CinS

    Get Age from BirthDate field in a Query

    Can anyone tell me how to create a new field that gives the Age, based on an existing [BirthDate] field in a query. I don't know if it should be a function or expression, or if it should be VB or SQL and I don't understand how to write it. Then, how do you add it to a new column in a query...

Part and Inventory Search

Back
Top