View Full Version : Date Query


PicassoB
12-07-2008, 06:34 AM
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
12-07-2008, 07:11 AM
Try =Date() +2 in your criteria.

Alan

PicassoB
12-07-2008, 10:46 AM
Hi Alan tried your recomendation - but the list came up blank again

PicassoB
12-07-2008, 11:10 AM
Alan working fine now found what I was doing wrong
Thanks for the help