Recent content by fkeller

Well set up the second report to only do the onhand calculation. This works fine, probably another way to do it, but this works so will go with that. Again thanks bob for all the help and time that you put in to show me how. Working with access is kind of a sideline in my job, so don't get a...

Well bob I see what you have done, thanks for the time it took to put together. I will have to rework it a little, as my query also groups by vehicle, and does the average KPG. So running sum overall does not do it. could also just set up 2 reports one for the KPG which is working, and one for...

Well not doing so good Have tried the following with running sum input the number of gallons purchased have this event gallonsrec - gallons. does not decrement the gallonsrec amount. each line item is subtracted from the orginal amount. have also tried gallonsrec=gallonsrec-gallons this...

So this would be only in the report? does not need to be part of the query that the report executes? sure can set the amount to negative then add the gallons used to that amount thereby decrementing the number. No way to stop a function from rerunning when you change to an active line?? Like I...

I notice 81 views. can someone answer the question on how to decrement the base number, the base query? Not asking someone to do it, but how have tried a few things but have not hit on it yet.

Other than I am not sure how, no. The function for figuring the KPG does not seem to run multiple times only the one for figuring onhand. How do you decrement the original starting number used for the calculation in the base query? Original number say 650gals, - the incoming usage from...

I have a query with 2 modules, 1 that figures average kpg works fine, and one that figures onhand, this one uses a form input for the amount of gallons that we have bought, and subtracts the amount of gallons consumed each time a we fill up. Seems to work fine until you touch one of the list...

Cannot see module1. only the query! understand the query, but need to see how your getting the previous record odometer reading.

Got it thanks for all the help guys for some reason just changing the as string to as varient lets them all through. Someday maybe I will know why. But now is working. Also had to set a field to equal yes or no it did not like nulls I guess

Query, is acting like it has a filter before it goes to the function. My understanding is all records should go it the function, unless there is a condition that is stopping it before hand. with a stop at the top of the function. I am only getting certain records through. my stop is here *...

WEll little by little am progressing, but now receiving function calchour not defined. My new function shows on the navigation pane as a module acts like the query never really gets starts as it should ask a couple of questions. SQL view SELECT [Main Labor].NOMBRE, [Main Labor].Cedula...

When I download his example I got the form and no table or function This is what I am trying to do. Trying to get this to operate as a function out of a Query. Is this possible, either as a sub query or something else. But needs to run prior to tax calculations. As it sets the Gross Salary...

I see the form but not the table, or function?? can you post again please

I have a similar problem and being very new to access and not a VB programmer, am wondering how/where you would install code of this type. Can it be in a querie or does it go into a form or report? Code was copied from another thread titled “Complex if” started by MTN, I have no problem...

As a very new access user, where would you be putting this code and how. I understand the code just not where/how to put it into a query or form or report??? Thanks for any answer.