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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mkc9929

  1. mkc9929

    append queries

    Structure of tblhours is: employeename, tmsemployeeno (PK), PGAC, reasonworked,payperiodending, dateworked, overtimecodes, hoursworked, hoursbanked, comments. I will post the one append query that somewhat works but does not "0" out the refused hours worked. I need to roll back the overtime...
  2. mkc9929

    append queries

    I have a database in which I calculate overtime hours earned and refused. I have tblhours which adds all the hours up which were worked refering to an overtime code. The same column in tblhours when refering to a different overtime code, ie: "2, 5, or 7" adds up all the overtime hours...
  3. mkc9929

    Total in Queries

    Thanks so much, it worked. Can I ask you a question so that I understand how and why it worked? Did the "0" in the formula recognize the empty fields? Thanks again...Melinda
  4. mkc9929

    Total in Queries

    I have a query that has dates of when an employee left work and came back on a worker's compensation claim, which they can do this up to five different times giving me 5 different dates to calculate. I have the five different dates in five columns in a query. This is example of the field with...
See more

Part and Inventory Search

Back
Top