Follow-Up Count

A

aparnawangu

Registered User.

Local time

Yesterday, 20:52

Joined

Aug 11, 2015

Messages

26

• Apr 18, 2016

• #1

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

 

Last edited: Apr 18, 2016

Minty

AWF VIP

Local time

Today, 04:52

Joined

Jul 26, 2013

Messages

10,659

• Apr 18, 2016

• #2

Your data isn't normalised properly, you should have a table for follow ups linked back to your main data. What happens if you need a 4th or 5th follow up with your current data structure?

Then you could just count the number of follow ups for each main record to get the data you need.

 

A

aparnawangu

Registered User.

Local time

Yesterday, 20:52

Joined

Aug 11, 2015

Messages

26

• Apr 19, 2016

• #3

Pls help me with the structure of followup table how it should be?
as i am very new to access


Regards
Aparna

 

G

Galaxiom

Super Moderator

Staff member

Local time

Today, 13:52

Joined

Jan 20, 2009

Messages

12,895

• Apr 19, 2016

• #4

The table would have a field for FollowUpDate as well as fields for any other information about the followup process. Some of these fields would hold Foreign Keys to records in other relevant tables such as the ID of the person who did the followup.

There would usually be a Primary Key such as FollowUpID to uniquely identify the records.

Then the followups can easily be queried by any criteria.