Case studies: innovative use of the union query (page 3 of 4)
With a union query we have split all records in two. The list below does not shows files anymore, it shows jobs (a job is either a file's packing or a file's delivery).
Now we are getting somewhere, especially if we sort the jobs on date, it gives us a list of jobs per day! But we can still do better than this!
First of all, we want to show each day as in a diary. Secondly, we want to visualise better which jobs are happening in the UK, and which ones abroad. As such it will be a better tool to schedule trips. next page >>