Search results

  1. T

    Need assistance modifying date query

    I have a query that is based off of a union query SELECT clvpertech.clvtech1 AS Technician, Sum(clvpertech.CLVCode) AS CLVs FROM clvpertech GROUP BY clvpertech.clvtech1; This is returning a sum of all the procedures a technician does for the entire database. This is working. I need to break...
  2. T

    combining multiple like fields and totaling

    Not exactly sure if a query is what I need in this situation or if it is what I need how to get there. In the attached db example on the case form there is a section for technicians to go in and take credit for steps that they performed as part of the overall case So clv1 might be done by User...
  3. T

    default value in a combo box from a query

    Hi all, New to the board and access (2000) I have been tasked w/ creating a database to schedule and track incoming cases for my job (Dental Lab) This entire thing is new to me but have developed most of it through reading this forum so thanks for that! I still have a long way to go... Here...
Back
Top Bottom