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.

 

[jwhite]

You don't need to triple-post your question to get seen! Likely you will get a message from the moderator...

You should not have repeating groups in your table -- in this case it is the Months. Your table is not normalized. Hard to tell what you are wanting, but I'm guessing something like a gantt chart? Post your table(s) structure and try to clarify what you desire to query/display.