=?Utf-8?B?VGVycnk=?= wrote:


My first table with expressions worked after I messed with the relationship
of the tables I had such a mess that I started over. Now the expressions
aren't working.
Pro Rate Table
Auto Num
Unit
MonthlyRent
DailyRent [MonthlyRent]/30
StartDate
EndDate
NumDays [EndDate]-[StartDate]
Amt [MumDays]*[DailyRent]

Originally I had Monthlyrent getting data from another field =adj rent .....
StartDate got data =LeaseStart+30
all the data is in the same table and the same form
any ideas...


My idea is to remove DailyRent, NumDays and Amt from the table. There is
no need to store those values since you can calculate them whenever
needed.
On your form you can add unbound fields with expressions like you
mention ([MonthlyRent]/30).

--
Groeten,

Peter
http://access.xps350.com