Calculated Fields Disappear

[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

 

[John Vinson]

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

What are the Control Source properties of the two textboxes?

John W. Vinson[MVP]

 

[Guest]

What are the Control Source properties of the two textboxes?

John W. Vinson[MVP]

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

Melinda

 

[John Vinson]

What are the Control Source properties of the two textboxes?

John W. Vinson[MVP]

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

Melinda

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]