Minggu, 24 April 2016

[MS_AccessPros] query problem

 

Access 2010


In this reduced database I have two tables one called Names and one called personal schedule.  I assign tasks to those who are available for a duty.  In the personal schedule table I have 5 weeks (for a possible number of weeks per month) and three opportunities to accomplish a duty each week.  If a person tells me they will not be available on a certain day I simply check a yes/no box to indicate No on that particular event/day.  Sometimes it can get complicated, and as I must do this each month I may not catch one of the "No" boxes to return it to Yes for the new month.


I would like to run a simple query to tell me who currently has any No box checked so I can make any corrections.  I will upload a file called Database31 which contains the two tables.

__._,_.___

Posted by: dyspoz2@cox.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (11)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!


.

__,_._,___

Tidak ada komentar:

Poskan Komentar