Follow-Up Count

[aparnawangu]

Hi Friends,

I have a table called Follow-Up and the fields in that table are as follows:


Follow-Up1,follow-Up2 & follow-Up3
Now i need a query which can determine how many total follow-up1 done,how many follow-up2 done and how many follow-up3 done in total probably for a week and month or for the date series which i will give.

Regards
Aparna

[ranman256]

you've designed it wrong. There should be on 1 followup field
clientID, followUp


THEN you can query and find out how many did what.
querys don't work left to right, they search down in a column.

[aparnawangu]

Pls help me out how to do that with the columns which i have mentioned above