Calculated Fields Disappear

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have a database that I created in Access 97. It has two calculated
fields, one that sums a field on my subform and one that counts the number of
records in the same subform. I've converted the db to Access 2000 using the
database converter and now my calculation fields just show up blank. Any
ideas on what's causing this and how I solve it?
Thanks,
Melinda
 
Hello,
I have a database that I created in Access 97. It has two calculated
fields, one that sums a field on my subform and one that counts the number of
records in the same subform. I've converted the db to Access 2000 using the
database converter and now my calculation fields just show up blank. Any
ideas on what's causing this and how I solve it?
Thanks,
Melinda
Click to expand...

What are the Control Source properties of the two textboxes?

John W. Vinson[MVP]
 
John Vinson said:
What are the Control Source properties of the two textboxes?

John W. Vinson[MVP]
Click to expand...

One is =Count(*)
The other is =Sum([TotalInvoice])

Melinda
Click to expand...

Very odd. I wonder if the Form has become corrupt? Try creating a new
Form and copy all the controls from this one onto it.

John W. Vinson[MVP]
 
Back
Top