I have a quert set up to a small database, and when i run the query to gather the information i need with WHERE conditions set all works fine and i have 38 results, which is what it should be.
Now in these results is an age column that contains ages between 6 to 15 with . 5 increments. (eg. 6, 6.5, 7, 7.5 and so on)
Now in the 38 results i get many of these results have the same age and i want to GROUP the results into ages, starting from youngest to oldest.
Now I selected Group in the Age Column and it said Group 1.
Then as i understand i also need to set up a Having Condition to be linked to the Group.
This is where i run into problems as nothing i try works.
The best option i get is 15 results from the 38, it just list the result that contains the 1st number in age. For example 8.5 i know there is 5 results with 8.5 however it only displays 1.
What am i doing wrong, is there someone who can help me.