Calculated Fields Disappear

M

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
 
J

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
Click to expand...

What are the Control Source properties of the two textboxes?

John W. Vinson[MVP]
 
M

Melinda

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
 
J

John Vinson

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]
 
Top