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

  • Users: bumfuzzled
  • Content: Threads
  • Order by date
  1. bumfuzzled

    Add number fields, and concanate text fields in duplicate records

    Every week I import timehsheets and they may have duplicate entries So I end up with something that looks like this Empl InvoiceIDActivityDate LeaseName Hours 703 136067 5/22/2008 Link Ranch #1 1.5 703 136067 5/22/2008 Link Ranch Bndry 10 What I need to do is filter for...
  2. bumfuzzled

    DSum expression with text criteria adding all records in table

    Hello all, I have an invoice table and a "Time" table. In the time table there is a mileage charge field, and a hours charge field, I am trying to add those together and total for each invoice in the Invoice field and update a field in the Invoice table with that Information. I realize that...

Part and Inventory Search

Back
Top