query for count of followups

[aparnawangu]

Hi Team,

I have a table called Follow-Up Status and the columns in the table are
Enquiry_Form No,Follow-Up_Needed,Follow-Up_Assigned_to,Follow-Up1_DueDate,Follow-Up1_Remarks


Likewise Follow-Up2 and Follow-Up3.
I have to create a query which should capture that how many follow-up1 are done likewise how many follow-up2 are done and same for follow-up3 also.

Pls guide me as i am very new to access.

Regards
Aparna

[June7]

This would be an aggregate (GROUP BY) Totals query. Use query builder. Search Access Help or web for guidelines.

Or build a report using its Sorting & Grouping features with aggregate function calcs in textboxes. Again, search for guidelines, lots out there.

Or get an introductory tutorial book to learn the basics of Access functionality.

These are basic Access functionality.