quering current date to display data

D

Dave S

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?
 
R

Rick B

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


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?
 
J

John Vinson

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?
Click to expand...

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

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