Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Controlling size of a query

Discussion in 'Information Technology' started by Ben Coffey, Jul 28, 2006.

  1. Ben Coffey

    Ben Coffey
    Expand Collapse
    Guest

    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
    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.
     
  2. Loading...

    Similar Threads Forum Date
    General Controlling Kaam (Lust) Hard Talk Apr 8, 2014
    Money and Controlling Spending Questions and Answers Nov 18, 2011
    USA Anti-Islam pastor called controlling, "mad" Breaking News Sep 13, 2010
    Opinion Manmohan Singh Phenomenon: India's Grand Strategy of Controlling the Thought of Sikhs Breaking News Jul 8, 2010
    Technique Of Controlling Mind Gurmat Vichaar Jan 27, 2008

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    >> I have an table full of inputs and one of these inputs determines how many
    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
    > 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.
     

Share This Page