Form/Report question?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey
I am using the Inventory Control template in Access '03. I made a form similar to the Purchase Order for
called Issue Order ( it enables me to issue items in stock to custodial and maintenance personnel). When I try to
preview the order in a report using a command button I get "The specified field '[UnitPrice]' could refer to more than one table listed in the FROM clause of your SQL statement. How can I avoid this so that I can see the order before printing it
Thank you.
 
Most likely, you have two fields in the record source query of your report,
that are identically named [UnitPrice]. Open the query in design mode and
rename one of those fields to something unique, like
"PiecePrice:[UnitPrice].
-Ed

JGranger said:
Hey,
I am using the Inventory Control template in Access '03. I made a
Click to expand...
form similar to the Purchase Order form
called Issue Order ( it enables me to issue items in stock to custodial
Click to expand...
and maintenance personnel). When I try to
preview the order in a report using a command button I get "The specified
Click to expand...
field '[UnitPrice]' could refer to more than one table listed in the FROM
clause of your SQL statement. How can I avoid this so that I can see the
order before printing it?
 
Back
Top