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 gkittelson 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: atz
  • Order by date
  1. atz

    Concatenate 2 DateTime fields

    hi, I have 2 different fields, both datetime, but 1 contains the date, the other the time. eg 01/01/01 hh:mm:ss and dd/mm/yy 10:00:00 how do i concatenate the date side of the first column, and the time side of the second column into 1 column? i have tried the & and the + functions, as well...
  2. atz

    Passing vba variables to an SQL query...

    hi, this might be a red herring, but have you tried setting the dates as a 'YYYYMMDD' format, then passing in as a string? Regards ;-)

Part and Inventory Search

Back
Top