Recent content by Chelle1661

Thanks for all of that Mihail! Post 6 is correct i.e. Litres/Kilometers Here is the original formula from the Excel Spreadsheet: "Usage" field: =IF(E26>0,F26*100/E26,0) E26 is Kilometers driven between yesterday and today (sometimes 0) F26 is Litres of Fuel pumped into vehicle between yesterday...

p.s. am getting so confused with all of this and wondering if any of these #Num and #Errors relate to the integer property in my table [set at single currently]..?

Where do you think is best? In the Query or the Report calc field Control Source? Am trying report calc field at present.. Thanks!

Chubbardsr, As a very amateur access user, [I have no VBA or SQL] please forgive my question: Where would I place this function? I continually waste time on these zero problems so would really like to try your solution. I did try to create my calc field in a report but have been troubleshooting...

P.S. I have also tried to place the Iif statement in the report's underlying query in the Consumption calc field. [My calc field is Consumption: [VehicleLitres]/[Kilometers] and the #Error only shows in results where there is a zero in the VehicleLitres field]. I tested this by inserting...

Hi Mihail, The VehicleLitres field stores the number of refuelling litres per day. Sometimes that is 0. The Kilometers field stores the mileage travelled per day. Sometimes that is 0. I will check the original Exel spreadsheet formula to see how that should be converted in my Access...

JHB, thanks I will try and find some time to do this!

Hi All, About 2 months ago I posted the following [See below] in an attempt to resolve a #Div/0! error relating to my report. I have still not managed to find a solution as no matter how I typed in the expression I kept getting syntax error messages. Having tried all of the numerous...

Hope these screenshots will help: http://www.access-programmers.co.uk/forums/album.php?albumid=57&pictureid=180 http://www.access-programmers.co.uk/forums/album.php?albumid=57&pictureid=179 These are two separate vehicles grouped by Week,VehicleCategory and then Vehicle. At present I only...

Tried 0 but that did not work either. Always a syntax error!

Tried : =IIf(([VehicleReading]-[PreviousReading])<>0 and IsNull([VehicleReading]-[PreviousReading])= False, ([VehicleReading]-[PreviousReading]),"N/A") but still getting invalid syntax message?

Thanks for your response plog, So, I wanted to test my caluclated field Kilometers for 0 first but I get syntax error message. =IIf([VehicleReading]-[PreviousReading]<>0 and IsNull([Kilometers])= False, [Kilometers], "N/A") I put [VehicleReading]-[PreviousReading] instead of [Kilometers]...as...

Hi, I am trying to get calculated fields in my report to work but zero values in the data are throwing up #Div/0! and #Error! and #Num! The main data fields I am trying to work with are: VehicleReading PreviousReading VehicleLitres My aim is to track mileage and consumption for a fleet of...

Re: Can anyone help with my Sub Query mayhem? REFERENCE PREVIOUS RECORD As per above, I have not been able to resolve the problem with Multi-Level GROUP BY clause [which is not allowed in a sub query] therefore I cannot total on the report that references the query. Now I must seriously...

Re: Can anyone help with my Sub Query mayhem? Running Difference Problem Well I managed to get a reference to the previous reading with help from Allen Brown re: sub queries. http://allenbrowne.com/subquery-01.html I now have PriorValue and Difference fields in my query so that I can base...