Hi,
I have a database, in MS Access 2000, with a table containing a set of orders. One of the fields in the orders table is the month. I want to be able to view the previous months order, this was initially done by having the criteria for the month field set to one less than the current month, found by = Month ( Date () ) -1. This works for almost everything but, I the month of January there is a problem, this is because the month, 1, take one is 0. This needs to be 12 to display Decembers orders.
I don't know if I need SQL or anything. I'm a bit new to anything more than relatively simple queries.
Thanks
Phil
I have a database, in MS Access 2000, with a table containing a set of orders. One of the fields in the orders table is the month. I want to be able to view the previous months order, this was initially done by having the criteria for the month field set to one less than the current month, found by = Month ( Date () ) -1. This works for almost everything but, I the month of January there is a problem, this is because the month, 1, take one is 0. This needs to be 12 to display Decembers orders.
I don't know if I need SQL or anything. I'm a bit new to anything more than relatively simple queries.
Thanks
Phil