Search results

Thank you :cool:

Hi,, And thanks for responding, yes is a very scary, :D The months you are refering are two separate fields altogether, the first group are projected expenses and the second set are actual expenses. I was given the task of duplicating an excel budget analysis within the database, if this...

Hi All, Here I'm again, I have a query 1 that sums up each field to get a subtotal, the second query2 sums up query1 my question is can I get this two combined into one and get the same result, or is there a better way? what Qry1 SELECT TempQry_Subtotal_Proj_HC.Type...

Thank you for your help, I really appreciated and I learned something new what's all about Dennis

No, I did not, however when I Typed (see below) in the control source, it worked. =Nz([July1])+Nz([August1]) :confused:

When I inserted, Private Sub TOTAL_BeforeUpdate(Cancel As Integer) Nz ([July1], 0) + Nz([August1], 0) End Sub I get a syntax error. :confused:

Hi John, Thanks for the quick reply. I have never been able to write code succesfully, so my q? is the nz() function goes in the control source Ex: nz(July1,0ifnull]) or does it go in the event procedure before update? Please advise, Dennis:confused:

I have an unbound field =[July1]+[August1]+[September1]+[October1]+[November1]+[December1]+[January1]+[February1]+[March1]+[April1]+[May1]+[June1]. However some of this months do not have any entries, so I do not get a total unless I manualy ad a zero where needed. How would I approach this...

Hi Poppa Smurf, Please forgive my luck of code writting, I'm still confused, If I send you a copy of what I have so far would that be OK? Please let me know Dennis

Thanks-Dennis

The calculated field is an unbound field for a single form, is there way to do so with code instead of the conditional feature in access? Please advise Dennis

Correct, is not working with Switch() function :confused:

Hi pbaldy, This is what I did and is almost perfect, the conditional part is not working I get the same color for everything and the condition are set correct as far I can see, I will keep trying,,,Thanks so much Dennis =Switch([1st Quarter (Actuals)]/[1st Quarter (Projected)]>1,"Red",[1st...

Hi Poppa Smurf, Thanks for your reply, let me see if I can get this going. My control source reads as follows =[1st Quarter (Actuals)]/[1st Quarter (Projected)] anf I wanto to get the background change and the word shoul match. >100% "RED" =<100 "YELLOW" etc. Thanks again Dennis:)

Im looking under help, but still not clear to me, I know is me Thanks Dennis :confused:

Hi Paul, Thanks for your quick response, I was able to do the conditionl part of it, but the IIf() or Switch() function, have no clue Thanks Dennis

Hi All, I have a calculated field that reports in percentages Example: 341%. Based on the output anything Higher than >100% should give a message "RED" with a RED background and <= "YELLOW", and =100% should be GREEN Color. Hope it makes sense, anty help would be greatly appreciated...

I found the solution to my own question and would like to share it The code that I'm using is: Private Sub Cmd6_Click() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Investment plan Number] = '" & Me![Cbx1] & "'" If...

Thanks for your quick reply, because the criteria is selected from two cascading combo boxes, a cmd button is required to go to the specific record, now this is objects are contained in a single form and it does not filter to the correct record. When I had two formas A and B it worked fine...

Hi All, I have form A and form B, in form A I have two cascading combo boxes and a cmd button that once the criteria is selected it open form B in the correct record, however I copy the objects from A to B to eliminate two forms and just using one form, now when the criteria is selected, it...