Form controls in a query

[Guest]

I have a relational data base, of which the Main form has 2 subforms for
Services & Fees, and the other relates to payments received. I have created
controls on the Main form which total for EG: fees which refers to the
Subform and Payments which refers to the other subform. Then another control
which shows the balance still due. These total without any problems on the
Main form. What I want to do is design a report which will show only those
that have not paid in full. I tried a text control referring to the control
on the form but all I get is "Error".
Any help would be appreciated

 

[Guest]

Hi Roger,

I assume you are calculating the balance due 'on-the-fly', instead of
storing the results of a calculation in a table. If so, can you create a
query that includes this same calculation and add a criteria >0? Use this
query as the recordsource for your report.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I have a relational data base, of which the Main form has 2 subforms for
Services & Fees, and the other relates to payments received. I have created
controls on the Main form which total for EG: fees which refers to the
Subform and Payments which refers to the other subform. Then another control
which shows the balance still due. These total without any problems on the
Main form. What I want to do is design a report which will show only those
that have not paid in full. I tried a text control referring to the control
on the form but all I get is "Error".
Any help would be appreciated