Help with Access Query

[dae2604]

hi I'm newby in Access pls help me with this simple query

I had a Table named ORDERS,

In the ORDERS Table I had A Field named >> OrderDate

i want to show all the Oders with the current System month and year

e.g today is Oct/21/2010 then all of the orders for the month of OCT and year 2010



Many Thanks!!

[Rixxe]

Guessing something like this:

SELECT Orders.*
FROM Orders
WHERE OrderDate = Oct/*/2010

Really odd date format, the '*' should just allow any day.

Or

You can just use the filter option if its in a table.

[weekend00]

SELECT Orders.*
FROM Orders
WHERE month(OrderDate) = month(date())