Expression Builder

  • Thread starter Thread starter Alex Parks
  • Start date Start date
A

Alex Parks

When I create an expression formula in a form field,
the returned value does not show up in the table or
Query.
How do I display the returned value?
Thanks.
 
A text box can be bound to either an expression (calculated/formula) or a
field. The control source can't be both.
 
How do I calculate a value in a form and take the result
and write it back to the table?
Or, would it be better to calculate a value using
2 fields and store the result in a field and then
just display the result field in a Form?
If the later is best, do you have any suggestions on
how to perform the task?

alex
 
There is generally no reason to store a value that can be calculated. I
don't know what you are calculating so I can't justify saving your
calculated value.
 
I have created a database for billing my clientele.
I have created simple math expressions for summing
in one of the forms I use to print out billing invoices.
However, I need to query the unpaid invoices, using
a form. But when I view both the table, (inwhich the
form is designed from), and the newly created query,
using the aame table, the "TotalPrice", TotalMileage, and
TotalParts show $0.00. Yet the Form and the Report both
show the correct sum totals.

I just want to reuse the same table to create a query,
then use the query to design an Invoice Control Form,
which I can enter payment info and mark the invoice as
paid.

Thanks for your assistance so far. I think I need to
take some Access classes and learn more about creating
expressions, macros and conditions.
 
I still don't see any reason to save the calculated value since you will
always have the numbers available to recalculate.
 
Back
Top