Replies

Hans,

That worked beautifully.

Thanks again!

Thanks Hans!

Thanks for not giving up on me and my crazy requests.

Funny, I thought that 2 Star lounger was really something…until I saw that I only have 100 posts total. Doesn’t compare to 41k.

Have a great weekend!!

I really am making this difficult for you, aren’t I??? I certainly do not mean to.

I know that going into 2006, this graph will be displaying data for 2005 as well, just because we like to keep 12 months of data showing at all times. If the date range were from Feb 2005 through Feb 2006, the very 1st Qtr avg should include Jan, Feb, and Mar of 2005.

Maybe I should go back to the drawing board. Question…will graphs only work with continuous ranges of data? Would it be possible to set up the data in month order and then have all of my QTR averages at the bottom, but yet set up the graph so that they appear as M,M,M,Q Avg, M,M,M, etc…

Wow, I just became a 2 Star Lounger!

Sorry Hans! Ran out for a bite to eat.

In answer to your questions, and forgive me for not providing you with the information that you needed in the first post. The QTD Average should be the average of the sum of Express_BookedLoans & SBALOC_BookedLoans/sum of Express_ActualFTE for Oct, Nov, and Dec 2004. This is the referred method for viewing (see attached graph). If it can’t be done, I certainly understand, and will look for another way to save myself from all of those manual updates each month.

Thanks again!

Wow!!! I just became a 2 Star Lounger

Sounds strange doesn’t it. Initially, someone would go and change the sourcedata for the graphs each month (32 graphs), and that is what I am trying to prevent (all about saving myself some time). Those graphs reflect 12 months worth of information to view, including QTD information. Is something like that not possible?

Thanks so much for taking a look at this Hans. As for the incomplete qtrs, I would ideally like for the formula to calculate the 2 months that you do not see,if that is possible.

Thanks Richard,

That took care of the Null values that I found in some of the data.

Thanks Hans!!!

That worked great.

It worked like a charm! Thanks again Hans!!!

Hans,

Certain puncuation seems to be causing Run-Time Error 3075. Specifically the “apostrophe”. Any thoughts as to why this is happening?

Thanks!

Once again thanks for sharing your infinite wisdom with me!! It works perfectly. You are fabulous!!!

Hans,

I am getting syntax error 3075. Syntax error in string in query expression “Null)’

Hans,

Thanks for the help, I have made the necessary adjustments to the “UPDATE” statement and it works great. I have the following code for the “INSERT” statement and am not sure how to add that the If IsNull statement to this.

sSQL = “INSERT INTO tblSample (SDate,AssocName,QARep,Manager,Site,Department,” & _
“ARN,ARNName,Function,ErrorType,ErrWgt,QANotes) ” & _
“VALUES (#” & Me.txtSdate & “#, ‘” & Me.cboAssocName & “‘, ‘” & _
Me.cboQARep & “‘, ‘” & Me.cboManager & “‘, ‘” & Me.cboSite & “‘, ‘” & _
Me.cboDepartment & “‘, ‘” & Me.txtARN & “‘, ‘” & Me.txtARNName & “‘, ‘” & _
Me.cboFunction & “‘, ‘” & Me.cboErrorType & “‘, ” & Me.txtErrWgt & “, ‘” & _
Me.txtQANotes & “‘)”

Thanks for your help

Francois,

The field “QANotes” does not have to have a value, and the code (in it’s current state) will not let me add or update a record unless there is a value in txtQANotes. I tried to add the following snipit of code, but this did not fair too well:

If IsNull(Me.txtQANotes) Then
sSQL = sSQL & “QANotes=Null, ”
Else
sSQL = sSQL & “QANotes='” & Me.txtQANotes.Value & “‘, ”
End If

Any suggestions?

Thanks again!!

Thanks so much for your help with this!!!