Subtotal and total in footer

[punter]

Hi,

The attached database has a form called The Book. There is a column called Duty. The data in that column is being pulled via Dlookup onto the form. The problem I am having is with the subtotals and totals. I have several of them set up in the various footers and they are working but not for the Duty.

I cleared out a lot of the data so it is easy to look at. The first subtotal and the report total should be $700.00. If someone could look at it and tell me what I'm doing wrong it would great.

Thanks in advance.

Eddie.

 

[GohDiamond]

your dlookup statement in the report is in error
Invalid Control Property: Control Source and
Circular Reference
=DLookUp("[Duty]","Container_Vendor_Information","[ContainerNumber]=""" & [Reports]![The Book]![ContainerNumber] & """")
Change the name of this field to something else or you'll have to put the talble name infront of the field like [Broker Information].[Duty] in your lookup formula

I didn't see a FORM called the book but I did see a report with that name so I'm guess you wer talking about that report.

I hope this helps,

Goh