| | |
|
|
|
access and frontpage |
|---|
| message from =?Utf-8?B?Y3M5N2pqbTM=?= on 19 May 2004 |
help..............please
SELECT Results.*
FROM Results
WHERE (((Results.Date_advert_ends)="30" And (Results.Date_advert_ends)>=[date]))
ORDER BY Results.ID DESC;
but when in front page recieve error. want i am trying to do is
SELECT Results.*
FROM Results
WHERE (((Results.Date_advert_ends>=[TODAYS DATE????+ 30 days]))
ORDER BY Results.ID DESC;
|
| Graham R Seach replied to =?Utf-8?B?Y3M5N2pqbTM=?= on 20 May 2004 |
SELECT Results.*
FROM Results
WHERE (((Results.Date_advert_ends>=Date()+30))
ORDER BY Results.ID DESC;
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
"cs97jjm3" <james@siobahnsherry.co.uk> wrote in message
news:A283602A-AC19-4CC8-8CC8-0DD646D71F4C@microsoft.com...
(Results.Date_advert_ends)>=[date]))
|
|
Archived message: access and frontpage (MS Access Database)
