Cumulative refequency and multiplying total by set criteria

[T-Dal]

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!

 

[Uncle Gizmo]

>>>which calcuates the cumulative frequency<<<

I'm not sure what you mean by that statement please could you explain.

 

[T-Dal]

sorry, frequency is not really the right word to use in this case its more of a 'running total', however i am trying an alternative method now - http://www.access-programmers.co.uk/forums/showthread.php?p=769287#post769287