form based on multiple queries 1

[SpyPnch]

I have a continuous form with multiple fields and entries that I get from one query. My problem is that I am trying to add another query to this form which is just the sum of one of the fields. Is this possible? thanks

 

[PHV]

Use a textbox in the footer section of the subform and set it ControlSource property to a fourmula clculating the Sum.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SpyPnch]

muchos gracias PHV

 

[genomon]

Hey spy - that would be "muchas", por favor...

"Business conventions are important because they demonstrate how many people a company can operate without."