Search results

The report form will not let me total in the group footer the calculated fields I have in details. Is there some way to do this without a subreport or in the query?

It's working, but a little trouble Your query works great with my table, but I have a small problem. The >0 and <5 did not return values that were exactly the same. (0 difference). I need those values also, so, I changed it to >=0 and it returned a bunch of duplicate values that were not right...

DCX693, that looks great. I will try it this weekend. My next hurdle is doing the time diff with that long date format, but I think I know what to do. Thanks again! (FoFa, your second one is correct. The times are all in the same field.)

I have a table with a date field that has date and time together. I want to use a query (not code, please) to return only those values that are within five minutes of each other. In other words, if my records are: 5/30/03 5:55 am, 5/30/03 6:05 am and 5/30/03 6:08 am - I want to only return the...