Search results

Yes. It doesn't like the * at all. When I remove them it still gives me #error.

Just a little after I tried what you suggested. I tried the code you gave me but I am still getting this erorr when I populate the report: #error

I'm trying to follow your suggestions but so far I still can't get this darn thing to work. It's driving me crazy.

I changed the name of the text box name to: txtTotalConsents The control sourse is: =IIf([txtTotalConsents]=0,Null,Sum(IIf([Qtr]="1 Qtr - 2011",[FindingTotal],Null))/[totalconsents]) The textbox shows #error. I'm not sure if I am doing it right but I know we are getting close. Thanks!

I'm not exactly sure how I would do this. Can you write the code out for me? I've tried every way I can think of but no luck thus far. Much appreciated!

Thanks for the codes. I modified the last one to fit. Here it is but I have a calculation problem. =IIf([TotalConsents]=0,Null,Sum(IIf([Qtr]="1 Qtr - 2011",[FindingTotal],Null))/[TotalConsents]) My total consents are: 356 My total findings are: 32 ------------------------- The Total...

I figured out waht I wanted to accomplish for this part. This is the code I used: =Sum(IIf([Qtr]="1 Qtr - 2011",[TotalConsents],Null)) =Sum(IIf([Qtr]="1 Qtr - 2011",[FindingTotal],Null)) Now what I need is to get a percentage out of these. When I try this code: =Sum(IIf([Qtr]="1 Qtr -...

I created a query breaking down the qtrs named Qtr. The output is 1 Qtr - 2011, 2 Qtr - 2011, etc... The rest of the columns remained the same. I tried =Sum(IIF(DatePart(Qtr) = 1 Qtr - 2011 AND Year(DateofAudit) = 2011, [totalconsents], Null)) But I still can't get it to work at all. I...

Here is what I use in my table: dateofAudit------TotalConsents-----Totalfindings 1/1/2011-------------30---------------4------- 2/1/2011-------------59---------------16------ 4/1/2011-------------15---------------0------- Etc... hope this helps!

No, I don't have it broken down by quarters. I am using a table for the graph I created. Everything works great but this issue. I already have the years totals but need it quarters for the Director. Everything is coming off the dateofaudit column. Don't quite understand post 3, sorry...

=Sum(IIF(DatePart() = q AND Year([dateofaudit]) = 2011, [totalconsents], Null)) This is what I tried but I am getting an error for wrong arguement. Not sure what to put in the ??. In the table I don't have it broken down by quarter, just the date entered that I am trying to use to get my...

I also tried this: =Sum(DatePart("q",[dateofaudit]=2011,[totalconsents],Null)) I need to pull by qtr (1st qtr, 2nd qtr, etc), by year and the "totalconsents" in those guidelines. The error I am getting is: Data Type missmatch in criteria expression. Year = DateofAudit and Totalconsents...

How would I add it in with I need to get what I want? I have tried a few different ways and I can't get it to work. This is what I tried: =Sum(DatePart("q",[dateofaudit]) and [FindingTotal],Null)) Thx

I understand that formula, but I have to sum the FindingTotal with the quarter and by year as well. This is the example I tried in a different script. =Sum(IIf(Year([dateofaudit])=2011,[FindingTotal],Null)) I thought something along this line would work.

I want to count how many (FindingTotal) I have done by quarter (dateofaudit) in my report. I used this formula to get my numbers for the year: =Sum(IIf(Year([dateofaudit])=2011,[FindingTotal],Null)) Now I need to the same but break it down to quarters. How would I convert this to quarters. Thanks!

All suggestions worked well. Thanks again!

It did not like nulls in the Letter column. Thanks!

Neither is the case. I am only using one table so there is no outer join and I am only using a few rows that should not cause this problem. Puzzled. This is the SQL view. TRANSFORM Sum(QryConsentsforGraph.FindingTotal) AS SumOfTotal SELECT (Format([DateofAudit],"q"" Qtr - ""yyyy")) AS Qtr...

I created a query to pull information from my table. The query is a crosstab and I am getting <> in a cell that has no information. I know what the problem is but can't figure it out. Here is what I have in each of the crosstab: (Year([DateofAudit])*4+DatePart("q",[DateofAudit])-1) Group By...

Thanks for your input! Both worked as advertised.