It Works !!!!
Thanx. It seems it was my own stupidity. I was trying to do the sum in the page footer instead of the report footer. DOH!.
Cheers for your help.
Chris
Hi,
Nope. Still not working. Even if I only have one record in the sub report and try to sum that value to the footer of the main report it shows as #Error.
The Code I am using for the total is ...
= Sum ( [Cost] ) + Sum([Cost summary on 1 tech subreport].Report!Cost)
The first Sum is the...
Hi all,
I have a report with a total in the footer which uses the SUM function to total up currency fields in the records from the report. I have added a sub report in the report footer which also has currency fields which I would like to add to the total in the page footer. I have no problems...
Hi All,
I have designed a database using forms as a user interface. To make everything look neat I have removed all the toolbars at the top of the screen and also have a macro which maximises each form on 'Open' and 'Activate'. Unfortunately this has had the side-effect of making all the forms...
Cheers,
I think I got it working. The databse that I am designing is to store training records and I was needing the Yes/No field to show if the training had been completed or was still scheduled. I eventually got there by using a Query with a calculated field. Thanx for the help anyway though.
Hi all,
I am trying to get a Yes/No field in one of my tables to automatically change depending on todays date being earlier or later than another date field in the same record. Can anyone give me a rough idea of how to do this?
Thanx in advance
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.