Results 1 to 10 of 10
Thread: Can U SQL? Cos I need help
Jan 18, 2002, 11:35 #1
- Join Date
- Jun 2001
- Luton, UK
- 0 Post(s)
- 0 Thread(s)
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
Drew'As a computer, I find your faith in technology amusing'