Getting Can't Add or Update Records when Making Table with a Query (1 Viewer)

Micron

AWF VIP
Local time
Today, 04:31
Joined
Oct 20, 2018
Messages
2,059
OK, how's this: you're attempting to divide a number field by a text field. You can get away with that if the value can be interpreted as a number, but definitely not if it's text. See if I've interpreted the fields correctly as belonging to the calculation in the field that shows #Error...
ErrData.jpg
Obviously you cannot default the price field to 0, nor would 1 be of any use. Thus the headaches begin (if they haven't already). I'll PM you regarding your offer - unless you cannot or do not allow pm's.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom