Recent content by marckk

I have a an access DB that lisst 8 different columns of data, the header and and column value are the same, it's from a an online survey and the participants are suppossed to select one value given for a question. So there are lots of NULLs what i need is the pie chart to count all the non-NULLs...

Many many thanks!

Query1 Criteria = "1 week" Or "2 weeks"

So the total records that = (1 week + 2 weeks) / (1 week + 2 weeks + 3 weeks + I don't recall having an intake meeting + I don't recal how long it took + less than 1 week + More than 3 weeks)

ultimately i want a percentage, these two totaled and divided by the number of records.

if I want to count the total of two values in a column that has 5 values and 80 records, what's the best way to do that?

Hello, I have a chart with 7 slices in a report, I have the labels displaying as percentages. What I need to do is dispaly an overall score next to the chart. This score is made up of three of the slices added together. So in this example [1 week, 2 weeks & Less than 1 week] all get added...

Ok, so I guess I wasn't very clear, I apologize, but if anyone can answer the above I'm dying for some info. The picture below is an example of Page 1, it's four evenly sized pie charts. I'd like to create three more pages exactly like this, however there seems to be a size contraint? These 4...

You sir are my IDOL!! thank you very much! Worked perfectly:thumbsup:

I have a number of pie charts in a report being fed by a single query. What's the easiest way to have the record count show as a total number in the footer for that query?

Quick question though, can I set the date parameter within the criteria of the CollectorID count query?

I'll try that, thanks!

no primary key

here is my data: CollectorID235999532359995323599953235999532359995323599953235999532359995323599953235999532359995323599953 If I just bring in CollectorID I can use "count" in the totals section no problem, but if I need to limit by a certain date ">03/01/2012" it gives a breakdown of the...