Date Query

[PicassoB]

HELP please - I need to run a report from a command button using the attached query - the report needs to show any jobs that have 2 days left before the estimated completion date (a type of early warning system) the report can be run any day to show any jobs with 2 days left to run, I have tried a number of things with no success - struggling with the code to put in the criteria - has anyone done anything like this? would appreciate any help
Regards Richard

 

[Alansidman]

Try =Date() +2 in your criteria.

Alan

 

[PicassoB]

Hi Alan tried your recomendation - but the list came up blank again

 

[PicassoB]

Alan working fine now found what I was doing wrong
Thanks for the help