Graph by Date ?? (1 Viewer)

[spacepro]

Hi,

I am trying to generate a graph in access from a query. I can do this no problem, but I want to only show the last five days automatically. At the moment I have set the date range but once these dates expire the data in the graph will not show the last five days.

Is there an expression that I can use in the query or VBA code to do this?

Can anyone help.

Many Thanks in advance

Andy

 

[Rich]

Between Date() And Date()-5 in the criteria of your date field in the query grid

 

[spacepro]

Thanks Rich,

I knew it would be something simple.

Cheers

Andy