Search results

  1. S

    Adding time format in a COLUMN(not row)

    Got one for you! I am trying to calculate how much time is spent on tasks in a time criteria. I have created the query to filter a time period such as 8/1/02 to 9/1/02. In my table I have a column called time used which has a format like 4:40 meaning 4 hours and 40 minutes. In my query I...
  2. S

    Auto Select from another table

    I not very bright when it comes to access but here we go: I have two tables which one has an error code and a solution column. In my other table I have a table to record trouble shooting. When I type in an error code, I want the solution to automatically pop up that coincides which that...
  3. S

    Totaling columns of time(not rows)

    I have a table which in one column has a time formula such as 4:40 this is 4 hours and 40 minutes. I am calculating how much time was spent on a task. I cannot seem to figure out how to total a column. I want to do a query which is set up to filter certain date time lines. Within that date I...
  4. S

    Auto Selection from a Table

    Ok guys be gentle, this is probably a real basic question but here goes! I want information from one table to automatically pop up in another table. I have a table with error code, error description, solution, etc. In the other table I will record trouble shooting calls. When I key in the...
Back
Top Bottom