quering current date to display data

I have a database made that will display tides for given
locations on my website, but haven't been able to get it
to select the current day and the next 6 days. It always
shows the first date in the file. How can I get to
access the current date, then display that day and 6 more?

Not sure where you are displaying this, how your table is structured, what
your query looks like, etc.

To display records for the current date plas 6, you would need to do...

Between Date() and (Date()+6)


Rick


"Dave S" wrote in message
...
I have a database made that will display tides for given
locations on my website, but haven't been able to get it
to select the current day and the next 6 days. It always
shows the first date in the file. How can I get to
access the current date, then display that day and 6 more?

On Wed, 9 Jun 2004 11:11:18 -0700, "Dave S"
wrote:

I have a database made that will display tides for given
locations on my website, but haven't been able to get it
to select the current day and the next 6 days. It always
shows the first date in the file. How can I get to
access the current date, then display that day and 6 more?

Create a Query based on the table; use a criterion on the datefield of

BETWEEN Date() AND DateAdd("d", 6, Date())

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public