Count table values in access

[DXXPublic]

Hi all,




Im new to MS Access, i just started learning and i need some help with some of the stuff i need to do.


Ok this is the scenario...
Currently i attend to around 20 projects meetings per week and i use an Excel spreadsheet where i keep one tab per meeting with the following info: Task description, responsible person, dates, status, etc ... (Im not using project because not everybody that has to edit and update the information has it, so for cross usage, i have to use excel)


So, besides the 10 tabs im using a dashboard that shows, a simple chart with the meeting name, how many tasks are in total, how many of those are closed and it has a graph showing that same info. I use a COUNTIF formula to count the amount of items per sheet that say "Close" on the status and i use that to do the calculations.




Ok... So i decided to do something in MS Access to see if i could make it easier for the team to manipulate the data from the tasks. This is what ive done so far as a test


Created a table named Meetings with the fields Meeting_ID(AutoNumber), Meeting_Name, Recurrence, Next meeting, Minutes doc
Created a table named Tasks with the fields Meeting, Description, Status, Responsible
Created a relationship from Meeting_ID to Meeting so i can use a lookup on the Meeting field
Created a Report named Meetings_Report from the Meetings table
Created a Form named Dashboard and i added the Meetings_Report


..so far so good, im able to see the meetings info with the recurrence.




Now to the problem im having


As i mention earlier, i have a small chart with the name of the meetings, the total of the tasks for that meeting and how many were closed and from there i created the graph.


On MS Access i cant find a way yet to do so.
1. I cant find a way to something like a COUNTIF to count the items that have the status as "closed"
2. I dont know how to do something like the chart i was doing on excel to show the total/closed number per meeting


Any clue or pointer on where i can look for more info regarding this.


thanks in advance
J

[June7]

Aggregate calculations are usually done with GROUP BY (Totals) queries.

I best analyze chart issues when I can work with data. If you want to provide db for analysis, follow instructions at bottom of my post.