Search results

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

Thanks, That's not what I'm looking for, if I use count in the "Group By" section for totals then I'll just be counting the various dates. I need a record count not a total

I need to have a count query that just gives me the number of records in a table. I'll need to set date parameters but I don't need date data, just a total record count and I can't use "TOTAL" because then it counts certain dates? Any help or direction would be appreciated!! Thanks!

I have page one done perfectly, it's formatted spaced and sized and I have added page two (both are Landscape Oriented) but page three, no go. It won’t fit in the “DETAIL” section. Is there a limit on graphics or pages in Access 2010? Basically I'm trying to create a graphic report with 4 pie...