Search results

It depends on the formula. May I see it?

change the cell format to GENERAL. (You may have it as text!)

Oops, multipost ;) Assume a1 to a5 are your ranks. A6 is the total. A6 cell's formula would be: =sum(a1:a5)/countif(a1:a5,">0")

OK. Use the Countif function. =sum(a1:a5)/countif(a1:a5,">0")

right click on the control and change the layout to none.

An excel question? Cool. assume A1 to A5 is rank 1 to 5. A6 is the TOTAL in the A6 cell, I would put something like (depending on your totalling formula or course) =sum(a1:a5)/count(a1:a5) Is this close to what you need?

You are missing an "iif" function.... try: 104COUNT: iif([form104Count]="YES",sum([form104Count])+1,{whatever value you want on false}) Is this sort of what you're after?

OK, here's an update, but unfortunately still no success. I have tried just a simple report, using only the fields from the 'Orders' table in a simple tablature format. I still generate the same error. I have attached the following screenshots. error1.jpg = the error msgbox that keeps...

I don't know mate. Sorry. I'm new at this myself. I'd bet there's a way though.

Are you using Access 2007? If so, I just do it like this. Select the subform table, or table you are wanting the total column on, in Form view. Then apply a 'totals' row.

Hi everyone. My name is Dan, and I am a complete Access newbie. I am proficient in Excel and VBA, so I thought learning access would be a breeze. I was SO wrong! I am using MSAccess 2007 I have a problem, that I thought someone may be able to help me with. I have scoured the internet, Access...