Auto Positioning

[YTurnbull]

As a newbie to Access I am out of my depth on this one. Any pointers appreciated.

I have created a table with our site addresses and another table with the contractors who own these sites. We make collections from these sites 7 days a week. Occasionally we collect from these sites twice a week sometime fortnightly etc. At present I have 7 queries (one for each day of the week). I want to be able to give each collection a 'run position' ie the order they will be collected in (to be able to work a route for the driver) this being static until a new collection needs slotted in. How do I set what I am calling a run position which can be altered and effect the position of the items below it? There will also be the factor of two or more collection routes for the future.

Where do I begin?

Yvonne:banghead:

 

[shutzy]

for me it will all depend on what information you have. if all of the locations will be in the same town area etc you could arrange them by postcode. you could assign a value of distance from the depot and then arrange them by this. i think you are after a logistics program.

i have a friend that owns a huge factory and she employs someone to manage her logistics. she is a millionaire so i dont think money is an issue. if she could buy software to take the place of her employee then i am sure she would.

i am sorry if this has seen as a ramble but i am just thinking out loud.

do the different sites have a prefered collection time.

their could even be third party software that you could incorporate into access.

sorry if this reply has not been of any use.

 

[YTurnbull]

Hi - positioning choice is done manually because there are too many variables (routes, vehicle weights etc) - I just wanted to create a report for the driver to know where to go next.

Collection 1 - Site 20........
Collection 2 - Site 3
Collection 3 - Site 29....

Then if a new site comes along and needs to go into collection point 2 it will shuffle the exisitng 2 & 3 down to positions 3 and 4 etc.

Clear as mud?

 

[shutzy]

youve just made it muddier. i think i know what you mean. so you have all the data inplace(what collection is assigned to what driver etc) and you just need to display it.

that should be easy enough. do you want a report for each driver or do you want a continuous report?

 

[YTurnbull]

Hi - At present we only have one driver but should have another driver soon and therefore another collection route, so want to future proof my tables/queries/reports - so by driver I imagine.

 

[shutzy]

that should be quite simple.

on your ribbon click report design. i find it much easier doing it this way

then once a blank report has opened. go into properties for the report. click data tab and then record source. here you have your query builder. click the table(s) that you need for the data. then dbl click the fields you want to include in your report.

on the grid at the bottom your fields that you have chosen will appear. you and use the sort function there to sort your data in what ever order you like.

then once you have done that close the query builder(tab at the top, save). you then have a blank report again. like you do with forms you have to add fields. add the fields into details section of the report.

at this stage i would only include the details for the collection point.

top left on your ribbon you should be able to see a geen folder. clik this and it should display your data in the order you wanted it. it wont have a driver name but we will get to that soon.