Problems w/Expressions and matching a form w/the table

  • Thread starter Thread starter Munchkin
  • Start date Start date
M

Munchkin

I have two problems that have been driving me crazy! I just completed a new
database and have these two problems. I am sure it is something simple that
I am just overlooking!

1. when I enter new records in my form of projects, the information is
transferred to my table with no problems. But, if I am in forms, the records
do not show up! Why don't they match up? My forms can be on record 3 but it
shows up as record 10 in the table.

2. When I try to do a calculation in the expressions, it does not follow
through. I have read the help a number of times, but still can not get it to
work right!

ie: Loan amount=sum[(appraised value)-(first mortgage)-(second mortgage)]

Thank you for your responses!
 
Use a query between the table and form to set sort order.

Wrong syntax - In a totals query design view grid --
Field: Loan amount: [appraised value]-[first mortgage]-[second mortgage]
Total: Sum

Leave other field Total: as GROUP BY.
 
Back
Top