Thread: Expression
View Single Post
  #1  
Old May 12th, 2010, 06:28 AM posted to microsoft.public.access
terry
external usenet poster
 
Posts: 622
Default Expression

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...