Price/Units

  • Thread starter Thread starter ExcessAccess
  • Start date Start date
E

ExcessAccess

I have a make-table query. One of the fields is
called "price." One of the fields is called "units."
What I really want to do is have the price field
display "price/units". How can I accomplish this?
Much thanks in advance.

~J
 
When I use this, all I get in the field "PricePerUnit" is
#Error

How do I make it work?
Thanks again in advance.

TS
-----Original Message-----
PricePerUnit:[Price]/[Units]

--
Duane Hookom
MS Access MVP


ExcessAccess said:
I have a make-table query. One of the fields is
called "price." One of the fields is called "units."
What I really want to do is have the price field
display "price/units". How can I accomplish this?
Much thanks in advance.

~J
Click to expand...


.
Click to expand...
 
When I use this, all I get in the field "PricePerUnit" is
#Error

How do I make it work?
Thanks again in advance.
Click to expand...

Please post the actual SQL view of your query. Could the value of
[Units] be zero or Null? Either would cause an error.
 
Back
Top