Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. supmrio

    Reports: Including a percent and also a chart

    None of the charts pictured are for 1 or 2 fields, they all point to 3 parts. Unless I am not reading it correctly. If you think the answer is in the HELP somewhere, then by all means I will go there and dig it out. Just give me a little push, I will gain the speed! Thank you for all your time...
  2. supmrio

    Reports: Including a percent and also a chart

    Bob, About the Charts? Thx, Mario
  3. supmrio

    Reports: Including a percent and also a chart

    Bob,you hit a homerun with this one. That is exacatly what I wanted, albeit it took me all weekend to comprehend the SQL statements. Were I to want other queries to produce similar results, do I have to use the same concept? What happened to getting Percents at report time? And now to the...
  4. supmrio

    Reports: Including a percent and also a chart

    Hi Scriverb, i have a query that gives total of respondents - ID field - in TABLE "members" followed by another query that breaks it down by gender from the same table "members": GENDER COUNT female 78 male 22 I would like to show what pct of the total (ID) is...
  5. supmrio

    Reports: Including a percent and also a chart

    I have tried just about everything, in trying to show a percent on the report. I try to create a calculated field, but keep getting a "parameter" dialog box. I imagine someone must have crossed this bridge before, so, your input would be greatly appreciated. Also, on the Charts...
  6. supmrio

    GROUP BY and count on different fields same table

    Pwise and Lightning, thank you very much for your tips. Here is how i wound up doing it after trying both approaches. I used the CROSSTAB query facility. I found it rather simple to use. Adding queries , which I assume is the APPEND query facility, turned out to be quite cumbersome, after...
  7. supmrio

    GROUP BY and count on different fields same table

    Hi, I am new at ACCESS. WHen I do a query using let's say, the field called GENDER, and I have two rows, one with the GROUP BY in the total, and the other one with count in the total, output is correct, x amount of female, x amount of male, the first row has the words FEMALE and MALE, the second...

Part and Inventory Search

Back
Top