I own a big strange Zoo!!
I have 3 type of animal, Cats , Dogs and Mice.
I assign each new animal a unique number.
I tend to aquire my animals in batches.
i.e I might acquire 10 Cats. Then 6 months later I might acquire 20 mice. etc
In my fantasy world tblAnimals has grown to almost 500,000 records (1 per animal)
However, my IT manager says I must reduce the number of records substantially!
So, I need a QUERY that converts tblAnimals into a more efficient view...like below.
I.e. One record per batch. (tblAnimals currently has one record per animal which is wasteful!)
Animal Start End
Cat 1 6
Dog 7 8
Mouse 9 10
Cat 14 16
Dog 17 20
Cat 21 23