access and frontpage

[Guest]

help..............please

i have following sql statement as a query
SELECT Results.
FROM Result
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 i
SELECT Results.
FROM Result
WHERE (((Results.Date_advert_ends>=[TODAYS DATE????+ 30 days])
ORDER BY Results.ID DESC

 

[Graham R Seach]

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