Search results

  1. U

    manipulating data

    report help I tried entering in a range of data from ages 18 to 60+ in intervals of 5 (18 - 22, 23 - 27,.....) into a crosstab query that calculates there averages in relation to the other groups. The data is divided by sex (f/m) so I want to get an average for every single age group and sex so...
  2. U

    manipulating data

    I want to find the percentage of a specific amount of data in relation to the rest of my data. I've set up range expressions to seperate my data into 7 different sections. Now I want to create reports that have the percentages of these sections in relation to each other and 2 other variables. Is...
  3. U

    Condensing Information

    partition The increment between the data is not equal. Some increment is a different size. Is it possible to more than one range expression in a query for each increment or is there a different function that can allow me to specify the specific increments.
  4. U

    Condensing Information

    subreports or union query I need to create a report that condenses an takes the average and sum of all of the records divided up into there respected amounts. 0 - 100000, 100001 - 250000, 250001 - 500000...... I have already created 7 queries that have the information I need. Would it be...
  5. U

    Condensing Information

    I want to combine a large amount of data into 7 groups in a query. I want to get the average and sum of all 7 groups seperatly. I want to create a report that divides the 30000 records of numbers ranging from 0 to 2.5Mm into seperate number catagories. 1 - 100000, 100001 - 500000......etc.
  6. U

    Combining several queries into 1 report

    What is the best way to combine data from several queries (all data from 1 table) into a report? I want to group data from the table an have accomplished this by creating 7 queries representing the 7 headings I wish to present. How can use a report to present all of this data, hopefully without...
Back
Top Bottom