Query Value On Form

[uplink600]

Can anyone help please.

I have a report based on a standard query. The query extracts all live projects from the database table and displays them along with the total value of the projects. I also need this total to appear in a standard text box on a form that I have set up.

Can anyone advise how I can get this value from the query/report to display
on my form in my text box.
Thanks

VC

 

[Len Boorman]

Presumably your form is also based on a query.

Can you not add Proh=ject costs to this query

L

 

[uplink600]

Thanks

The form is built around the main table and is used to add projects to the database. I just want to display the total value of live projects (from the query I mentioned) on the form.

Hope you can help, I've been told I need to use the expression builder in the text box properties in form design but I havn't used this before.

Thanks

 

[Mile-O]

The form is built around the main table

Tsk, tsk!

The form should be bound to a query based on your main table.

 

[Len Boorman]

Create a form based upon the query but keep it small. Do not have a page header or footer.

Then with you main form in design mode drag this new form onto it.

It should behave like a sub form but without parent child links
Not sure about Expression Builder in this circumstance. You may get others who know more about Expression Builder offer some advice

Len