Value from expression in forms does not appear in report

[Guest]

I am somewhat new to Access, so I was thrilled (in a geeky kind of way) with
my successfull attempt to create an expression in forms. The expression is
the REMAINING BALANCE of what each of our clients still owes us (Total Fee
Owed minus each individual payment). In any case, I am trying to run a
report that lists which clients still have an outstanding balance with us.
The problem is, that when I run the report, none of the values from my
REMAINING BALANCE field appear (the REMAINING BALANCE field is the only one
that contains an expression). I mean, the lable REMAINING BALANCE is at the
top of the report, but where the values should be below that, all I see is
gaping blank space (nothing is there- not even zeros). The odd thing is that
when I view each record in forms, the REMAINING BALANCE field has a value in
it. How am I screwing this up? Any ideas?

 

[Duncan Bachen]

I am somewhat new to Access, so I was thrilled (in a geeky kind of way) with
my successfull attempt to create an expression in forms. The expression is
the REMAINING BALANCE of what each of our clients still owes us (Total Fee
Owed minus each individual payment). In any case, I am trying to run a
report that lists which clients still have an outstanding balance with us.
The problem is, that when I run the report, none of the values from my
REMAINING BALANCE field appear (the REMAINING BALANCE field is the only one
that contains an expression). I mean, the lable REMAINING BALANCE is at the
top of the report, but where the values should be below that, all I see is
gaping blank space (nothing is there- not even zeros). The odd thing is that
when I view each record in forms, the REMAINING BALANCE field has a value in
it. How am I screwing this up? Any ideas?

What you can do is to base your report (and your form) on a query.
Create your expression in your query to do your math for each record.

RemainingBalance: TotalFeeOwed-Payment

Then you can reference the field "RemainingBalance" in your form or
report and the expression is already calculated for you.

Alternately, you can have the expression calculate for each line of
detail in the report by setting it's control to =[TotalFeeOwed]-[Payment]

What's your expression look like?