Calculations on a Report

[racdata]

I set up an Overtime app in Access
Everything works fine - but I have a problem

On the report I have the sum of all overtime worked and the sum of all Sunday time worked

Also the Grand Total is displayed

Now the problem is ----

I need to put in the budget amount somewhere (I don’t know where) then the grand total must be subtract from the budget and display the amount left on the budget. Where do I put in the Budget, - Table - Query - or on the report.

I need to edit the budget annually and the new budget amount will be effect from the 1st April each year. I do have a field where I enter the current financial year. The budget total must be available in the next year if the auditors query the previous expenses on overtime

Thanx for all your help

 

[dynamictiger]

For the budget figure to be available to the auditors you need to store it.

You have not said clearly whether the report is an annual total report or a weekly total report.

If an annual total report you dould use a lookup as the source of the field to grab the budget and then in the report do the maths on the totals.

HTH

 

[racdata]

Calculations

The report will always be available whether it is weekly, monthly or annually.
The budget figure must be stored somewhere
i.e. I want to see what did we spend last year (2002/2003) a popup menu I will enter the financial year. Access will calculate all entries made for 2002/2003 and display/ print report.
If I then enter in the popup box 2003/2004 it will give me a report on the amount spent currently for this financial year.

On the report footer it must display the following
a. Sum - Overtime
b. Sum - Sunday time
c. Grand Total (Overtime + Sunday time)
a,b, and c is displayed

d. Budget for Overtime (-----)
e. Amount left for Overtime (-----)

d and e is the problem

 

[WayneRyan]

racdata,

Make two unbound controls and put them in the Report Footer.

Their default value is:

=DLookUp(.................)

See Help for examples, or search this forum, there are lots
of DLookUps.

Wayne

 

[racdata]

Thanx Wayne
I will try out your suggestion

 

[racdata]

I tried but I cannot get this working -

Is there an other salution to this problem - HELP PLEASE!!

If possible make it easy I am stil a rookie in Access

 

[WayneRyan]

rac,

Can you post a sample db? Compact/Repair, ZIP, then post.

Wayne

 

[racdata]

Wayne
When you open this don’t laugh. As I said I am still a rookie

If you want to change anything to make it better and work better I will appreciate it

Or you can suggest and I’ll make the changes – If I can

I had to delete the scwitchboard and the form

 

[WayneRyan]

racdata,

All that I did was to make the calculation:

[Budget] - [Text59]

Wayne

 

[racdata]

Thank you Wayne

I entered [Budget] - [Text59] but it did not work - When I open the report it bring up a messagebox and ask me to enter "text59"
Can you tell me why?

Then I copied the text box and it worked.

Thanx a million