Search results

Thank you for your reply. The records individually have dates assigned to them, so I naturally assumed it would use this to grab the most recent record (thedata table is date ordered). I will try DLAST tomorrow. With regards to the VALUE etc, they aren't my field names etc. I subbed them to...

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

Got it now, misread it at first. Cheers for the help guys!

Sorry, I'll try and clear it up a little. Basically "Rating" can be calculated to less than 0, but if it is should only show 0.

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