Re: Query To Retrieve Less Than or Equal To

Jacine wrote:
Yes they are numeric, not text. Although the units on hand is a
calculation. A sum of several bin locations - would that make a
difference?

It shouldn't. Do the fields in the data*** justify to the left or right? If
something is inadvertantly changing one of your values to Text that will be a
clue since Text fields align left and numbers align right. Using the Nz()
function can sometimes do this (he said while ducking his head).

(inside joke, sorry)

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.