Search results

To update, I got what I need by using "DSum" as the "Control Source" for the textbox on the form... =DSum("Job_Billed_Amount","Not Paid Query") where Job_Billed_Amount is the field from which I want to sum the values, and "Not Paid Query" is the query containing those values in its result...

Thanks. I'll see about getting a database sample posted when I get a chance.

Can you explain what you mean by "create a query for the form"? I already have a query that gives me the records, and I also made one that sums those records and the resulting virtual table simply has one cell containing the sum. I just started looking at DSUM. I don't know if it will do...

That isn't the sum I need. I need the sum from the values returned in the query. The query selectively pulled records from the table. I don't need a sum of all the table records.

The query is NOT the record source of the form. The source for the form is a table. Thanks.

I might be able to post some of the database, but it likely wouldn't help. This aspect, I think, is pretty straight forward... The form is used to interface between the user and the data table... to enter and display the data. The query just lets me know who has been invoiced but from whom...

Yes. The values I want to sum are from a query. The form's source is a table. The query looks at my table, picks out only those record which are marked as 'invoiced' but not yet marked as 'paid', and outputs the requested information matching those requirements. If I could figure out how...

I think the problem is that Access forms have one source and all controls on a form must use that one source. The only way I've found to get information from another source is to use a subform and make it use the additional source. But that sucks bigtime.

Could it possibly be that the 'control source' property for the textbox on the form is not able to understand that it should use the specified query as the source, rather than the form's source, which is a table? If so, how can I make the 'control source' property for the textbox look to the...

Thanks for the response. I have tried two ways of doing this. One is to use the sum function as I mentioned to sum the values via the "Expression Builder" via the properties for the textbox on the form. The second is to use a 'summing' query that, when run, creates a virtual table with one...

Using Access 2003, I am trying to display the sum of values in a field from a query on a form, and the box say #error most of the time, and I have no idea how to determine what the 'error' is. I have a query called "Jobs Not Paid" which returns some info on jobs that have been invoiced but not...