Parameter Query to display just selected column

[Dannyboy11]

Hi

I have a table that consists of

ID | Mornings | Afternoons | September 5th | September 12th | etc. (every Sunday through to April 24th)

Every field is a Yes/No (except ID). How can I create a query so that the user can enter in which date that they want to view, and then it only returns the users who are 'Yes' for that date.

Help is much appreciated
file:///C:/Documents and Settings/D...Registration Forms Returned/Staples, Liam.doc

 

[vbaInet]

Your design makes it hard for this to be possible. You would need to normalize it properly. How does next month's 'Sunday' dates fields get handled? Do you create another 4 or 5 fields for each sunday of the month?