Now that I've figured out what's going on, I'll play too....

Amy Needs Help!!!
Amy needs to mend her ways and be more of a team player.
Amy needs specialist equipment and treatment
Amy needs your help!
Amy needs help for life.
Amy needs a drug-dealer's testimony to free a teenager wrongfully accused of murder.
Amy needs a new pair of shoes...
Amy needs to be found
Amy needs to either wake up or start getting some extra will-power.
Amy needs to decide if this fits her idea of a good relationship
Amy needs a hug. A great big hug.
I think Amy needs more cheesecake.
Amy needs a loving, committed family who will provide structure and stability
and have the ability to understand her growing process.

Little Amy wants to play.
Amy wants to get rid of the mounted animals.
Amy wants a horse.
Amy wants me to pass along the following information to those of you who are
still looking for a place to stay.
Amy wants to help Chris, a sullen boy who keeps to himself.
Amy wants to work in
a particularly specialised area and has a relevant degree.
Amy wants Hannah's parents' number in Hong Kong.
Amy wants you to be a bridesmaid because you're my bud.
Amy wants you to know she's just like you.
Amy wants to get away from life with her ex-husband.
Amy wants to do 43 things.

Anybody an access expert?

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???