Controlling size of a query

I have an table full of inputs and one of these inputs determines how many
months of data I wish to create. I am planning on using the query a little
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12310-controlling-size-of-a-query.html
bit like a spreadsheet for the mathematical properties. I was wondering if
there is anyway I this input (number of years) to create a query with the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12310
coresponding number of months, and have them labeled.

For example, I would like to input 15 years and come up with months labeled
1 through 180.

I really like the ability in Access to create forms and reports, so I don't
really wish to go back to excel, but if I must well then I must.

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

>> I have an table full of inputs and one of these inputs determines how many
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12310
months of data I wish to create.

I do not understand this statement. Normally criteria in a query determines
the time span for the results.

>>input (number of years) to create a query with the coresponding number of months, and have them labeled.

In a Totals query you can use this as criteria for your date field --
> DateAdd("yyyy",-[Enter # of years], Date())

Then insert a new column on the left like this --
Month number: DateDiff("m", DateAdd("yyyy",-[Enter # of years],
Date()),[YourDateField] )

"Ben Coffey" wrote:

> I have an table full of inputs and one of these inputs determines how many
> months of data I wish to create. I am planning on using the query a little
> bit like a spreadsheet for the mathematical properties. I was wondering if
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12310
> there is anyway I this input (number of years) to create a query with the
> coresponding number of months, and have them labeled.
>
> For example, I would like to input 15 years and come up with months labeled
> 1 through 180.
>
> I really like the ability in Access to create forms and reports, so I don't
> really wish to go back to excel, but if I must well then I must.