Search results

Oh my gosh..... CJ... it WORKED!!!! I cannot believe it. A corrupted report???!!!! Whatever... It is fixed. Now I just need to go in and format it the way it needs to print out. You know, make it pretty. But all the functions work!!!! I cannot believe it. 2 full days of pulling my hair out...

Gina... did not work. CJ... I guess I will start working on creating the report from scratch now. Will let you know. Thanks!

CJ... here goes: WorkloadDate Hours Rate ExtendedTotal 8/20/2013 4.00 $10.88 $43.52 8/20/2013 4.00 $10.88 $43.52 8/20/2013 3.75 $10.88 $40.80 8/20/2013 4.00 $10.88 $43.52 8/20/2013 4.50 $10.77 $48.47 8/20/2013 4.50 $10.77 $48.47 8/20/2013 7.00 $10.77 $75.39 8/20/2013 6.50 $10.77 $70.01 8/20/2013...

CJ, I plugged in this instead of what I had in the query: ExtendedTotal: Round(([Hours]*[Rate])+0.001,2) Still did not give the correct total. UGHHHHH!!!!

CJ, The query: ExtendedTotal: Round([Hours]*[Rate]+0.001,2) Workdate Footer: =Sum([ExtendedTotal]) (for SubTotal) Report Footer: =Sum([ExtendedTotal]) (for Total Invoice) SQL View: SELECT AgencyTable.WorkloadDate, AgencyTable.TempID, AgencyTable.Hours...

CJ, That made the numbers correctly appear in the query. But the total still comes out as if it is seeing the original numbers; not the already rounded up number. Do I need to adjust something in the Total formula?

When I change to have the round function in the query, it rounds down instead of up. It is using the banking rounding feature and doesn't round up when it has a 5 on the end. How can I make it round up at 5. Functions work properly in Excel, but it is much more work to produce my report in...

I have tried looking through the info Gina sent... I even went to the custom rounding process - but too technical for me to figure out what to do to make it work. The SQL of the query is: SELECT AgencyTable.WorkloadDate, AgencyTable.TempID, AgencyTable.Hours, AgencyTable.Rate, ([Hours]*[Rate])...

Syntax Error comes up when using in query; also it takes off the 5 on the end of the numbers and doesn't round either way. i.e., 47.775 = 47.77 not 47.78

Would you put this equation in the query or the report footer? or both? ExtendedTotal:Round([Hours]*[Rate],2)

This is what appears in the query since I took out the CCur: Hours Rate ExtendedTotal 7.75 $15.00 116.25 7.5 $10.77 80.775 8 $15.00 120 7.5 $10.77 80.775 5.75 $15.00 86.25 6.5 $10.77 70.005 7 $10.77 75.39 4.5 $10.77 48.465 4.5 $10.77 48.465 4 $10.88 43.52 3.75 $10.88 40.8 4 $10.88 43.52 4...

I did not realize that CCur rounded to 4 decimal places... Thanks for that information. I took the CCur out of the equation and copied this: ExtendedTotal:Round([Hours]*[Rate],2) It still doesn't add up correctly. Short by pennies.

The totals in the details of report round okay. It becomes a problem when you are totaling the column of already rounded numbers. It seems to me that it is still seeing the numbers before being rounded and adding them up coming out a smaller sum than if you are adding the final rounded number...

I am currently working with a report that I have successfully used for years. But I have come up with a strange issue. We recently have had a change to our hourly rate that we pay and now the Totals calculation is not adding up the numbers correctly. In the query that the report is based from...

I live in New Orleans and I am an Administrative Assistant. I have used Access for about 10 years. I have created databases and provide reports from them on a daily basis. I have manipulated them for various departments for their use. I provide the only support for these databases here. My...