Recent content by spearson

I got it...Thanks- I changed the groupby in my TimeUsed Column to Sum like you said, then right clicked on TimeUsed and went to properties to change the format to short time and it is working perfect. Got one problem with the form that I created from that query. In my query there are six...

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

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

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

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