I made a query which extracts from tb1 patients name, adress, city and from tbl2 the dates of consultation. Result looks like:
PatId | Name | Cons1 | Cons2 | Cons 3 | Cons4 | etc.
1 | Johnson | 2-2-2004 | 17-2-2004 | 15-3-2004 | 10-4-2004
2 | Peterson | 7-2-2004 | 15-2-2004 | 1-4-2004 | 7-4-2004
Next I would like to count which patients came how many times in out practice in a given period (mmmm yyyy), so we can send them a bill per month.
I cannot figure out how to do this, so please give me some help.