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

Micron

AWF VIP
Local time
Yesterday, 21:55
Joined
Oct 20, 2018
Messages
3,478
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

Top Bottom