Cumulative frequency and multiplying total by set criteria
Hey Guys, i'm new here and i've come to ask a couple fo questions regarding a database i have recently been developing for a property letting company. ok firstly i have produced a report which will show each function date used in each faciltiy by each customer and the time they are in for each date shown:
what i want to do is create a new coloumn beside the time amount, which calcuates the cumulative frequency, then i want to be able to multiply that total by a hourely rate set by the user.
Any help is appreciated thanks!
Hey Guys, i'm new here and i've come to ask a couple fo questions regarding a database i have recently been developing for a property letting company. ok firstly i have produced a report which will show each function date used in each faciltiy by each customer and the time they are in for each date shown:
what i want to do is create a new coloumn beside the time amount, which calcuates the cumulative frequency, then i want to be able to multiply that total by a hourely rate set by the user.
Any help is appreciated thanks!
Last edited: