Search results

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

Hi Rainlover, I have tried using your example query but am still getting error messages re: syntax or operators! Very frustrating as I am copying your expressions exactly apart from my field and table names and it therefore should run as your example query runs!:confused:

Thanks, will give it a try!

RUNNING DIFFERENCE PROBLEM: I am an amateur Access user and trying to get a running difference into a query based on a simple vehicle table and a vehicle readings table. This query for a report which will show the daily difference in the odometer readings. The table lists multiple vehicles in a...

Hi Shutzy, Well my DB is too convoluted so I quickly copied the relevant tables and forms into a new DB and populated the tables with a few records. I hope this is okay [very simple as too much work to make the DB fancy!] Well here goes ...will try and do the upload now. Once again many thanks...

Hi, Yes, I work from a very basic [Work] form with a [WorkDetail] subform [only me using it!]. I just key in the data myself. Not sure how to save or export this file to upload to you [or will browse allow me into the DB to select the table?]. As you can see I am a complete novice! The same...