Hi
I need a help in programming Count function. In short: I have a DB for a hospital, i have a table with the patients name, adress and etc, also i have a field for Service date.
I made a query and found out how many patients we have seen in different years using Service Date field. But it doesn't look proffessional, becoz when i run a query i can tell how many of patient we have seen looking at the number of entries, but i want to creat a command which will display a message saying total patients for 2000 = 20.
How i can do it, i think i need to use Count, but nothing is working so far.
Thanx
I need a help in programming Count function. In short: I have a DB for a hospital, i have a table with the patients name, adress and etc, also i have a field for Service date.
I made a query and found out how many patients we have seen in different years using Service Date field. But it doesn't look proffessional, becoz when i run a query i can tell how many of patient we have seen looking at the number of entries, but i want to creat a command which will display a message saying total patients for 2000 = 20.
How i can do it, i think i need to use Count, but nothing is working so far.
Thanx