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

  1. bumfuzzled

    Add number fields, and concanate text fields in duplicate records

    I need to "combine" these records, because the duplicate entries are throwing off my totals. Two .5 hour entries rounded to an hour, produces two hours, when in reality it should be two .5 hour entries combined producing 1 hour. In addition, someone does manual data entry of these records into...
  2. bumfuzzled

    Add number fields, and concanate text fields in duplicate records

    GROUP BY is in the above SQL View it says GROUP BY [EmployeeID],[InvoiceID], [ActivityDate] My understanding of the SQL statement that you wrote is that it will combine the records for a view, but is not permanently updating the first recored with the information from the other "duplicate"...
  3. bumfuzzled

    Add number fields, and concanate text fields in duplicate records

    yes you can have more than one employee but they would not be combined, only the records with the same employee, same invoiceID, and Date. Basically, we round up charges from a half hour to whole, so if you have two entries from the same employee on the same date and invoice number, we wind up...
  4. bumfuzzled

    Add number fields, and concanate text fields in duplicate records

    what i have so far is at the top of the thread, lets say i have two rows that look like this InvoiceID EmployeeID Date LeaseName Hours Comments 135655 733 5-10 Link Ranch 2.5 Bndry 135655 733 5-10 Link Rnch #1h 1 well What I need is 135655...
  5. bumfuzzled

    Add number fields, and concanate text fields in duplicate records

    I read up on SQL this weekend, and I realized that I mis-stated what I want to do. I need to combine, permanently the LeaseName, Hours, and Comments field in two or more records when the Invoice# and Date and EmployeeID are the same. The duplicate records are throwing my totals in my reports...
  6. bumfuzzled

    Add number fields, and concanate text fields in duplicate records

    duh i didn't read your post well enough, sorry
  7. bumfuzzled

    Add number fields, and concanate text fields in duplicate records

    thank you so much, you are right the comments field was left off. How do I add the hours field together?
  8. bumfuzzled

    Add number fields, and concanate text fields in duplicate records

    yes, I did, and I am way over my head. I understand it, but not well enough to apply it here. Thank you anyways
  9. bumfuzzled

    Add number fields, and concanate text fields in duplicate records

    What I am looking for would be 703 136067 Link Ranch #1,Link Ranch Boundry 11.5 hours
  10. 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...
  11. bumfuzzled

    DSum expression with text criteria adding all records in table

    thank you Ph, I understood everything except the & "'" at the end. What is the meaning of this? I am not really clear as to the meaning of the quotes and double quotes except that they distinguish between text and number in SQL and I have not found a really good resource on this yet, can you...
  12. 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