selecting a range of 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.

 

[RuralGuy]

If I understand you correctly, it sounds like you may wish to revisit the design of the table. I would expect to see a separate record with a date field and a task field for each task you are describing. Maybe I just don't understand the current structure.

 

[IanFiTheDwarf]

Hope this clarifies

I have a table named Forecast in the attached file

Routing refers to the task to be carried out, Section is the workshop and in each month is the number of jobs to be carried out in that month.
The month fields carry on for several years.
There will be many hundreds of records with different combinations of Routing and Section with new record added regularly as new jobs arise.


What I would like to do is run a query on the Section and any six month range by entering the first month of the six.

For example if I wanted to see all the jobs to be carried out in section “WS 1” from 06/2007 to 11/2007 I would select WS 1 as the criteria in the section field and somehow select 06/2007 as the starting month to get the following.

Routing Section 06/2007 07/2007 08/2007 09/2007 10/2007 11/2007
P/C A WS 1 0 4 22 18 22 0
P/C E WS 1 20 12 0 2 0 0
ST WS 1 0 5 5 5 10 10

This way to look at the work planned in any section, in any six month period all I have to enter is the section and the first month.

It would also be useful to do the same sort of thing on a form so I could enter the start month and have only the Routing, Section, and six month fields visible.

 

[RuralGuy]

As I suspected, your Forcast table is not normalized. Here's one link you might find helpful. http://www.datamodel.org/NormalizationRules.html Search this forum and others and use Google for additional information on Normalization. Your goal should be at least 3NF (Third Normal Form). Once normalized, you will find your tasks *much* easier!