Price/Units

[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

 

[Duane Hookom]

PricePerUnit:[Price]/[Units]

 

[ExcessAccess]

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

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

.

 

[John Vinson]

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

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

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