quering current date to display data

  • Thread starter Thread starter Dave S
  • Start date Start date
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?
 
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?
 
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())
 
Back
Top