Pull data by week

[skw8966]

I have a search page with a date field.

I'm using Dreamweaver MX to create a page which pulls data from an Access query.

I would like to pull data for the whole week corresponding to the date entered on the search page.

Can someone tell me how this is written in the SQL for the recordset.

 

[alexanderthegreat]

Well you would need to form elements datefrom dateto
Then filter the first >= for the datefrom and <=dateto against the recordset.

 

[skw8966]

Thanks.