Can U SQL? Cos I need help
I am quite new to databasing and SQL queries and I am trying to write 2 queries but I'm not having much luck.
Firstly I want to search a table called products for all items receieved less than 7 days ago, then I need another query to search for items released after 7 days but no longer than 30 days ago.
For the first one I've tried - Select* from Products Where DateReceived > DateAdd(d, -7, Date ()) - which I undestand is search for products that are received in the last 7 days but when I try this query in Access 2000 it pops up a parameter box for 'd' and I have no idea what that means or what to do to get the database to recognise this query.
I'd really appreciate some help on this.
Thanks a lot