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

  • Users: h11
  • Content: Threads
  • Order by date
  1. h11

    TIME CALCULATION

    I have a query from which I am tyring to pull information from a total time field for anything greater than 30 minutes. Can some one tell me what the format would be thanks SELECT [Tbl FAC].Date, [Tbl FAC].[Time In], [Tbl FAC].[Time Out], [Tbl FAC].user, [Tbl FAC].[total time] FROM [Tbl FAC]...
  2. h11

    query shows blank table when no data found

    I have a query that I use to search for certain items. Is their a way I can have a message pop up saying no records found, if their is no data found. thanks Tim
  3. h11

    time calculation problem

    Time problem I have a database that I use to track computer usage by age groups What I need to do is track the total hours used for the month by groups. What I did was created a update query to that subtracts the “time in” with the “time out” and updates the total time field “Format([Time...

Part and Inventory Search

Back
Top