Anybody an access expert?

[pixiecrinkle]

Because I'm far from it.

I am such a geek, however, that I have an Access database that I use to catalog all of my yarn inventory. Seeing as how I'm trying to get into the business of design and consignment, I need to keep better track of my materials cost. So I'm setting up an access report that shows me how much I've got in a given yarn on hand.

I'm trying to set up a formula that would multiply the number of balls x price per ball. However, if I have less than a full ball, I still want to count it as a full ball for these purposes (seeing as how I can't just walk in and buy a half ball of yarn).

I know that what I'd do in Java: math.ceiling(number of balls) * cost per ball. But I can't seem to find a ceiling function in Access, and I've had no luck googling to find it. The Round() function isn't cutting it, because it's rounding down (even for .5, which is odd to me).

Help???

Comments

[luminesque.livejournal.com]

I'm by no means an expert, but all my database work has been in Access. I'm too lazy right now to open one of them and check, but try ROUNDUP instead of ROUND.