Search results

Hi Plog, Thanks for the post, I've taken your advice and have now managed to get to the same point using just one query. I still however need to find a way to sum records from this query. I currently have 12 Months By Airline Airport, Month, Fuel Uplift USG, Airline, AirlineMonth ACE, 1...

I have what I'm pretty sure is a simple issue but it currently has me stumped and any help would be greatly appreciated. I have two queries which pull fuel uplift figures by airport from a master table, each query for a separate airline. Each record is made up of Airport, Fuel Uplift, Month...

Thanks for your help, I have now managed to solve the issue. I did try to use =Sum(IIf(Len([Comments] & "") = 0, 1, 0) however it kept coming back with an error that I'm sure was pretty simple but I couln't solve =Count(IIf(Len([Comments] & "") = 0, 1, Null)) This on other hand worked...

Just tried your solution and it resulted in all counts coming in as 0 which I guess suggests there are no zero length fields. I have checked the zero field length allowed property in the table and this is set to yes so shouldn't be an issue. Have also tried adding a trim function so the...

Hi I'm having some issues with a count function within my report. My report is a set of flights grouped by commander. Within the commander footer I want to show the percentage of their flights for which there is an attached comment. At the minute however I am unable to even count the number of...