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 biv343 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. southernweyr

    query does not return total if one table doesn't have excact match

    I figured out a way to do it. I have the make & model table (previousmake&model) and if a new model is put into the new table (flightdata) I update previousmake&model with an append query. This puts all make & models into previousmake&model. Then I use the left join query to give me totals...
  2. southernweyr

    query does not return total if one table doesn't have excact match

    I was wondering, if I have a few names in one table or the other that aren't in both how would I have a query return totals for each name. In my limited understanding I created a left join query then a right join query and then queried both of those queries. So that gives me all the names and...
  3. southernweyr

    query does not return total if one table doesn't have excact match

    Thanks, the left join worked. Now if I can just read that article so I can understand why.
  4. southernweyr

    query does not return total if one table doesn't have excact match

    Even if I do/don't get the LIKE figured out I still need the total of previous time even if their no record in flightdata that matches. That is the main problem.
  5. southernweyr

    query does not return total if one table doesn't have excact match

    thanks, any help is greatly appreciated
  6. southernweyr

    query does not return total if one table doesn't have excact match

    If previous has R22 and flightdata has R22 B II, I still want the total of R22 and R22 B II. It might also be something like R44, R44 Raven II, R44 Astro, R44 Raven. Or H269C, S296C, 269c, 269cb, 269cbi. Thanks
  7. southernweyr

    query does not return total if one table doesn't have excact match

    I have two tables. One for previous time in make & model and one for adding new time (flightdata). I have a query that will get the sum of time from flightdata for each make & model and another query that adds the make&modelnewtotals total to the time from previousmake&model. The problem I...
  8. southernweyr

    Updating Multiple Records

    sorry I posted in the wrong forum. My question is about Access.
  9. southernweyr

    Updating Multiple Records

    I was wondering if you have multiple columns in a tabel that you want to update on condition of multiple other columns what you would do. This is how I do one update, but I have several different helicopters that need to be updated. If model column of helicopter is 269C then set total time to...
  10. southernweyr

    using the sum of two fields to get a total sum

    Thank you very much for your reply. Both of your suggestions worked great. The first one is what I wanted for what I am doing.
  11. southernweyr

    using the sum of two fields to get a total sum

    I have tried to calculate the sum of two fields with little success. I have been able to combine the numbers in two fields by using SELECT [hours data].hours AS hours, [hours data].[total hours], Sum(Nz([hours],0)+Nz([total hours],0)) AS total FROM [hours data] GROUP BY [hours data].hours...

Part and Inventory Search

Back
Top