Search results for query: *

Thanks for the tip. I wrote two conversion functions, one to convert to "decimal time", then do the running sum, and another to convert back to "true time" and used these on every record line in the report.

Thanks to all respondents. The problem was indeed that I had named the module the same as the function inside. It is a nuisance that this "error" does not appear anywhere in the "Help"! and the message you get when you do this are totally misleading! As soon as I renamed...

If I add times in records using Running Sum the time rolls over when the total exceeds 24 hours e.g. when the next record time of say 1:30 is added to the previous total of 23:00 I get 00:30 instead of 24:30 displayed. How do I stop this happening?

This may be pretty basic but it seems so simple that I cannot find the answer! I have successfully used access '97 for some time with some pretty complex reports and now want to add/use a module to do some simple frequently used calculations (like VAT). No matter how simple I make the module...