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

Calculation on a form and a report

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 some of the calculated fields are not being populated. The
database is a samll invoicing database on the form and report 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 sub form and
subreport, linked to the master form and report by Part Number. On the
form and report we 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...

=([Quantitly1] * [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
Share on Google+
2 Replies


P: n/a
In your extended cost calculation, Quantity is misspelled. Is
frmPartDetailSubfrm1 the subform control on the main form and not the name
of the subform? frmPartDetailSubfrm1should be referred to from the Forms
collection like this:
Forms!frmPartDetailSubfrm1

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Del" <dt****@yahoo.com> wrote in message
news:c2*************************@posting.google.co m...
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 some of the calculated fields are not being populated. The
database is a samll invoicing database on the form and report 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 sub form and
subreport, linked to the master form and report by Part Number. On the
form and report we 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...

=([Quantitly1] * [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 #2

P: n/a
Del
Sorry for the misspelling. As for the frmPartDetailSubfrm1, that is
the name of a subform that is on the main form. The subform has the
Part Description, Unit Cost, and a couple other columns of data
related to the specific part number. The subform is linked to the Main
Form via the Part Number. The Subform is populated when a part number
is entered in the main form.
Like I said in the original post this calculation has worked for a
number of years. Nothing has changed in the database. The only that
has changed is some of the users have been upgraded to Access 2003.
Users that have either Access 2000. or Access XP have no trouble at
all with this calculation function.

Thanks,
Del

"PC Datasheet" <no****@nospam.spam> wrote in message news:<YB******************@newsread3.news.atl.eart hlink.net>...
In your extended cost calculation, Quantity is misspelled. Is
frmPartDetailSubfrm1 the subform control on the main form and not the name
of the subform? frmPartDetailSubfrm1should be referred to from the Forms
collection like this:
Forms!frmPartDetailSubfrm1

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Del" <dt****@yahoo.com> wrote in message
news:c2*************************@posting.google.co m...
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 some of the calculated fields are not being populated. The
database is a samll invoicing database on the form and report 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 sub form and
subreport, linked to the master form and report by Part Number. On the
form and report we 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...

=([Quantitly1] * [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 #3

This discussion thread is closed

Replies have been disabled for this discussion.