Recent content by supmrio

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

Bob, About the Charts? Thx, Mario

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

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

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

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

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