469,622 Members | 1,670 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,622 developers. It's quick & easy.

Calculated Field Problem Access 2000 DB and Access 2003

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
0 1329

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Norbert Lieckfeldt | last post: by
1 post views Thread by Cady Steldyn | last post: by
2 posts views Thread by John | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.