Printing rows based on data in colums

[pairak]

Hello, I am completely new to access but want to try to make some basic user databases at work. One thing I would like to have made is sorta an attendance list. I have a database with users and want to input what days their supposed to attend, then I'm gonna make a form with some buttons that either generate a list for overview/print or directly prints a list based on the cell data. For example, A button that auto prints a list of the users that is supposed to attend on Monday, another for Tuesday and so on, all with easy access and as few steps as possible to use. So in the database I have separate columns with a simple yes/no field for each individual day, so I will want it to print the list with selected colums based on which users have that particular day set to "yes". Is this possible?



In advance, thank you.

[ranman256]

yes, 1. collect all the data into a single query for that range. (date range, or confRoom range)
then
2. make a crosstab query to display it all as a single 'week sheet'

use the query wizard, choose crosstab query,
pick the range qry (in 1 above)
it will ask you for the field to use as row field (people)
the column field (days of week)
and the intersecting value (yes/no)