Date in a Query

  • Thread starter Thread starter PhilK
  • Start date Start date
P

PhilK

I'd like to develop a "auto query" where the data is
automatically refreshed when the worksheet is opened.
The problem is that I'd like the data to be the latest 15
days that are kept in an Access Database.
Example: "Between Today -15 and Today" . I can do it as a
an input function but I don't want the user to input just
look at the data. Also the goal is to generate charts,
make some calculations, and Excel would be the program to
use. Any help on this subject would be
appreciated. ... Phil
 
Hi there,

I have had such an issue, and this is the way in which I
have solved the problem.

Create a named range in Excel that stores the startdate,
now()-15, link the Excel file (and the named range) to
the Access database.

Base your query that you wish to feedback into excel, on
date ranges betwen the linked file value, and now().
 
Back
Top