By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,852 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

Calculated Field Problem Access 2000 DB and Access 2003

P: n/a
Del
Thanks in advance for any help.

I have a database that was created in Access 2000. Several users have
been upgraded to Access 2003. Since upgrading to 2003 we have noticed
that one of the calculated fields are not being populated. The
database is a samll invoicing database, on the form we have
columns call Unit Cost. This is the actual cost of the part and is
pulled from our parts master table and is displayed in a subform whick
is linked to the master form and report by Part Number. On the
form we also have a column call Quantity which is the number of
the parts ordered by the customer. We then have a calculated column
called Extended Cost. The Extended Cost has the following
calculation...

=([Quantity1] * [frmPartDetailSubfrm1]![Unit Cost])

This calculation has worked fine from the time the database was
created several years ago, until now. When the database is run on a
machine with Access 2003 this calculation doesn't work. However the
machines that have Access 2000, or XP the calculation works fine.

Any ideas????

Thanks again.
Del
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.