count of follow-ups

[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

 

[arnelgp]

create an aggregate query:

SELECT [Follow-Up_Needed], Sum([Follow-up1]) As Followup1Total, Sum([Follow-up2]) As Followup2Total, Sum([Follow-up3]) As Followup3Total From [Floow-Up Status] Group By [Follow-Up_Needed];