Could you use the Single data type in place of the Double data type for the Quantity field? If so, what's the difference?

---

Reply from Richard Rost:

Yes, you could. Single offers less precision and a smaller range of values but saves a some space. I always say if you're not sure, stick with Double. Unless space (size of the database) is a concert, go with Double. If you start running into the 2 GB file size limit, then you may want to consider scaling back to Single. I don't remember the exact sizes off the top of my head (I covered them in Access Beginner 3, Lesson 1) but you can Google them (or watch that lesson).