Recent content by Dgavilanes

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: