G
Gary Nelson
In Access2000, I have a query that I created for books being pulled from
inventory. There are two seperate inventories that books can be issued
from. ReturnedBookInventory and StandardBookInventory. Both fields are
designed with a check box. When the check box is checked, then the book
will be issued from the designated inventory. This part of the query works
fine. However, I also have a field called DateIn, which is when the order
for the book is received. I want to show all orders received on a
designated day. In the criteria section of the query, I have entered [Enter
Date In] which once a date is entered, should give me only orders for that
day. The criteria for ReturnedBookInventory = True and
StandardBookInventory = True. When 3/6/03 is entered as the DateIn, I
should only receive one order. However, I am receiving this order and 107
others from other dates. Any ideas?
I hope this isn't to confusing.
inventory. There are two seperate inventories that books can be issued
from. ReturnedBookInventory and StandardBookInventory. Both fields are
designed with a check box. When the check box is checked, then the book
will be issued from the designated inventory. This part of the query works
fine. However, I also have a field called DateIn, which is when the order
for the book is received. I want to show all orders received on a
designated day. In the criteria section of the query, I have entered [Enter
Date In] which once a date is entered, should give me only orders for that
day. The criteria for ReturnedBookInventory = True and
StandardBookInventory = True. When 3/6/03 is entered as the DateIn, I
should only receive one order. However, I am receiving this order and 107
others from other dates. Any ideas?
I hope this isn't to confusing.