access help with time

[d3vil112]

hi guys i need help with my project ..almost done but got stuck in the last part..

Q:
The dispatcher selects and offers whatever car returns the soonest, with some bias though. If a company-owned car is to return within 10 minutes from the earliest returned car then the dispatcher offers and dispatches the company’s car.n how do u know if a car is available or not.

what kinda coding should i be using in qry ...all helps appreciated.

 

[mike-strawberry]

Hi Dv3,

As your post is 4 days old, I'm not sure if you have now got some help from somwhere else, so before I do to much work on it let me start by asking (kind of suggesting) if I have got the wrong idea to suggest that the dispatcher needs a basic operational form to work off which is based on your central table. The query that supplies that form will have at least one calulated field in. What this is depends on my understanding of your data. If the time of return will be the leaving time plus the 'timing' then the query that supplies the form apart from including the obvious fields will need to also have an expression field which adds timing to leave time to give you return time. The equation could be inserted into an Iff statement which adds 10 minutes to the return time if the car is privately owned. All despatches then work equally on this 'effective return time'. When you say return times I presume you mean to thier own area. Is it possible they could get to another area and that they may be better placed to pick up from that area rather than return first. If so the logic would not quite be the way I have started out with. Am I way out from what you were looking for?

Cheers, Mike ps I probably wont be able to reply back for about 20hrs from now.