well actually I didnt use any code but I just created the data report..drag and drop the controls onto the report..but I just don't really know how to make a report show stocks that are less than 100.
well this is what I did, I went back to Access where the data came from and I made another column, naming it Stocks <100 and putting a checkbox next to every item and checking those items that have less than 100....or is there another way to do this????