Hello!

First of all let me say a big thank to all the people contributing in this forum helping us improving our VB knowledge ... Now, let me post my question!

I have an application where number from 0 to 60 are my entries and saved into a tbl with the relevant Date of Entry. I run an SQL query, count and grouping numbers according to their frequency and date of entry and send them to a form. Up to now everything ok. What i need now....

Assume that we have a table with the following type of records:

1 12
2 10
3 22
4 8
5 6

The first column is the Number Entered and the second one is the Frequency. I want to run a Select Query, Order by Ascending Order and present the results on textboxes, E.g from the above example to have 5 boxes and the relevant results. How?

Actually I need to know how to play with the SQL query ...

Thanks