mcclaren
05-24-2009, 05:51 PM
Hello all
I created a query in Access 2007 that is the “call back list” for a large animal vet. The clients are to receive a call 7 days after the farm visit. The “callback date” field in the query uses a DateAdd function, adding 7 days to the “date of farm call” field (date format is MM/DD/YY). I then wanted to add the parameter criteria “between[start date] and [end date] to the callback date field, so that the receptionist could get a list of the call backs that she needs to make for a given time period.
The problem is that when I add the parameter criteria, only the “double digit” dates within the range are returned, ie. Only dates later than the 10th of the month are returned, the first to the 9th days of the month are not. Help please.
I created a query in Access 2007 that is the “call back list” for a large animal vet. The clients are to receive a call 7 days after the farm visit. The “callback date” field in the query uses a DateAdd function, adding 7 days to the “date of farm call” field (date format is MM/DD/YY). I then wanted to add the parameter criteria “between[start date] and [end date] to the callback date field, so that the receptionist could get a list of the call backs that she needs to make for a given time period.
The problem is that when I add the parameter criteria, only the “double digit” dates within the range are returned, ie. Only dates later than the 10th of the month are returned, the first to the 9th days of the month are not. Help please.