Show Query Result In Textbox

[Aussie60]

Hi

Can someone tell me how to get the result of a query into a text box on the main form. The textbox is in the main form footer.

Can you please give me a step by step directions as I am not very experienced in Access 2003.

Any help would be appreciated

 

[John Big Booty]

What is the data that the query is collecting, that you are trying to display?

 

[Aussie60]

The data from the query is a total $ Amount

 

[John Big Booty]

In that case you should be able to simply set the Text Box Control Source as;

=Sum([FieldNameToTotal])

or even

=Sum([Units]*[UnitPrice])