Query - Date parameters in more than one column

[oni1983]

I have a query in which I have generated 6 columns containing different dates. I created 6 columns as I need to distinguish between each column (ie. Column 1 refers to 1st visit, up to 6 visits).

Now I would like to know if I can use parameters to bring up all visits planned for a particular month. The parameter worked when I inputted it in the column of the 1st visit but when I repeated the parameter for all 6 columns it went bonkers and all visits, regardless of the month were displayed.

Can this be done?

 

[Joe4]

It sounds like what you have is a design issue, that is causing things to be harder than they have to be, namely, your data is not normalized.
You shouldn't have repeating data like that in a single record. How you should set it up is only have one field per record with visit number, and then one for visit date.
So instead of having what you have, you would have six records of data for your six visits.
Then, when you search by date, you are only searching one field, not six.