Multiple group-by functions in one recordset or linking two recordsets

Is there a way to create multiple group by functions to generate
different variable within just one recordset. What i have is a load of
data on different species. I need to be able to count how many
different species there are (using COUNT(DISTINCT)) and how many
individuals of each species there are. So i need to have one variable
that is calculated from grouping them by species (as well as habitat,
date and replica) and another that is grouped by just habitat, date
and replica to calculate the number of different species there are.

I also need to display the different species with their counts
alongside which would either mean it will need to be in the same
recordset and make some sort of nested repeat region or have two
recordsets that are linked. Can you link two recordsets together like
that?