Between Function

[Guest]

The problem I have is as follows.

I have 10 vehicles that I have scheduled tests for at every 5,000 miles, and
I have a database that can tell me what the current mileage is for each of
these ten vehicles.

I would like to be able to include in my report what the next test is and at
what mileage (i.e. 5,000 or 10,000 or 15,000 miles.....)

I am currently using a 'between' syntax with the estimated date for each
test, to highlight when the vehicles are due, but these dates are very
unreliable.

Can I use the 'between' syntax on the mileages themselves? Something that
will capture any tests due within the next 10,000 miles from each vehicles
current mileage?

If anyone has any help, I would appreciate it.

Thanks

Chris

 

[Jeff Boyce]

?Are you saying you want to look for tests appropriate to a mileage that is:

Between [CurrentMileage] And [CurrentMileage]+10000

Regards

Jeff Boyce
<Office/Access MVP>