Search results

I have a database set up, and the end query basically gives me three results for my data. Last Value, Average Value & Max Value. For whatever reason, the last value does not seem to work correctly. It only seems to include the original records, and no records which have since been added...

Hi, I have written a select query that provides me with a numerical result. However, I would like the Result to never be less than 0. Is it possible to end a select query with some form of IF statement that would print "0" if the result was negative?

Basically, I have a table of data with plenty of records (10,000+) They all have 4 fields in common which must have data entered. The unique data is TIME. I have already done a group sort query which has identified the group's of data based on these 4 fields, and then calculated an average...