Pop up form has one field and needs result of query

[JimJones]

Hi,

I have two problems regarding a query and a form field.

The pop up form has one field it should display the result
of a calculation in my query.

I ge the ?Name# error, and I've specified using the builder right down to the query field.

The other problem is that I want my query to total all the service charges of all the customers.

Another query I have which totals all the service charges of thepresently displayed customer works. I guess I don't know how to total all of the customers together.

Please help,
Thanks,
Jim

 

[dcx693]

If there is only one field being displayed on your pop-up form, you might want to consider using a simple message box instead. However, there are good reasons for using a pop-up form (such as making it modal so that it retains the focus until cleared). What is the control source of the field and how is the pop-up form being called?

As for your second problem, how what is the syntax of the query?

 

[JimJones]

Hi,

It works now. I switched some things around, and I think it's giving me what I want.

Thanks,
Jim