Where to start?

[YTurnbull]

I am a Newbie - basics only

I work for a glass collection company - and I have numerous spreadsheets which
contain all our data. I want to bring all this data together and make use of it.

I have started a table with our site addresses and the days these sites need to
have a collection (sometimes more than once a week - decision being made manually as site added to database) and the number of bins that need to be collected.

I want to give each driver (two - currently) a list (report) of what sites they need to visit on a day .

The drivers report back to me with the number of bins collected and a weight collected from each site.

Ultimately I want to collate this information so I know how much has been collected from each site / averages etc.

Dont know how to go about creating a form that I can use when entering in the collection data - I want to be able to 'see' only the Sites which have a collection for a day (ie a Tuesday - not a specific date)

Really confused as to what to start first. Any assistance appreciated.:banghead:
Yvonne

 

[YTurnbull]

Hi Pat,

How do I allow for two or more collection days for one site? ie. Site A- collection on a Monday & Friday.

I also have sites that are only collected once per month or fornightly or only when they call.

I had initially set the table thus (see attached) - with your previous suggestion I would need to alter this. Again where do I start? I keep going round in circles...:banghead:

Cheers