This is a final assessment for a level2 Access exam:

Edit the report layout to include a new label and field placed as the last column on the report:

Label text = Balance

Field = enter a formula to calculate Budget less spent

Underneath each column of figures, (Budget, Spent and Balance) add three more fields - these will display the report total for each colum

I've added the label and field, and done the calculation in the field. But I can't get a report total for the new field :(

In the end I created the new field in the query that the report is based on, but reading the instruction above it appears it should all be done in the report.

When I add the total field in the report footer and I preview it, it brings up the 'enter parameter' box, and whatever I enter in this box appears in the group total:(

It seems to me that it's to do with the field name, it's currently "Text44" and I can't seem to rename it. I've just changed the report footer formula to =sum([text44]) and the parameter box still comes up!

Sorry to witter on, but I suspect the assessment is wrong (but it could be me). As there are 2 queries to create. A basic one, and then the above. The basic one is to be used as mail merge source, but then the recipients have to be filtered to "where the budget holders have overspent", and the above query has that info!!!:confused:

I hope this makes sense.

Thanks in advance for any help:)

Text44 sounds like the textbox name and not the field name

Hi,

Yes that's probably the problem!!! How do I create a new field in a report please, or do you think it's assuming I do it via the query?

Thanks