selecting fields

[IanFiTheDwarf]

I have a table holding the number of each task planned each month, with a field for the name of the task and a field for each month stretching of for a number of years, and would like to be able to open a form or run a query on the present months field and the following six months without having to have a seperate form or query for each starting month.

any help or a point in the right direction would be apreciated.

 

[pbaldy]

It is bad form to keep posting the same question over and over. Research normalization, as having each month as a field will cause you no end of problems.