Search results

In my combo box I have several names. When I select a new name, I should get a new record. This is so simple; I just can't put my hands on it. I have attached the db. Please tell me what I am doing wrong. Thanks for taking the time to review.

I have a text box with the following statement: Summary detail: Sum(IIf([dacthc]=0,Null,Fix(100*[dqty]*([dstdhc]*[drate]/[dacthc]-[drate]))/100)) My question is, if it meets the criteria, is it possible to make it default to a "0" in the field. Thanks for taking the time to look and review

Pat, good thought as well. I tried the IIf statement work great, but I have other information in the table that has to be calulated. I have this working in subform, therefore there is additional information that I need to calculate. I used the following in a query...

Pat, thanks ever so much for your help. Here is the bottom line I have been told in some cases these *Fields* are *Zero*, and *division by Zero* is illegal. So I hope I can get a work around. Once again thanks

Let me go ahead and upload the db. The qry that is giving me fits is called "QryWorkProduction Summary". Once again thanks for all who is chiming in

What I think I better do is give you what I have as my field properties in the table itself. I am just about ready to walk out of the office and I will continue this. I don't want to waste you time, not giving you the full picture. Thanks guys

All three is are a Number field and with a field size a Single with format as Currency. Don't tell me that is where the problem is? When Mr larson chime in makes me think what did the heck did I do!!!!! WVacthc <>0? If not, use the Nz function............... This one will take some time to...

spikepl, crap.......... I got the overflow again

Spikepli to be a little bit more clear on the syntax error "the syntax error in date in query expression"

SPIKEPL, thanks for chiming in, now on your suggestion I got a "syntex error" pr2-eugin it calulated out to differen't number all together. I like to say thanks to the both of you who are helping me on this confusing issue. I wish I could give you more clear explanation of the problem.

pr2-eugin, thanks for the quick reply. Any chance did you take a look at the attach file. I tried to show everyone what I had, due to all of this is confusing to me as well. I will use the formula as you posted and see how that works. I will post the out come. Once again thanks for the input.

I have confirm that its the: Sum(Fix(100*[WVqty]*([WVstdhc]*[WVrate]/[WVacthc]-[WVrate]))/100) AS [Summary WV] But I don't know how to fix the problem Any ideas

Pat, this is a somewhat of a double post. but I thought i let you know what i came up with. I use this code to fix the problem, but when I did I received a error of overflow with error 2950. Here is what code I used: Summary detail: Sum(Fix(100*[dqty]*([dstdhc]*[drate]/[dacthc]-[drate]))/100)

Can anyone point out where I can correct the overflow error. My thought it has to do with the WV Fix. This all came about trying to convert a excel formula to access. I attach the sample of the file from excel. I put it in a word document, but I think you get the idea what I trying to do...

Once again thanks Bob, you are the man

How do you move the Form footer close to the Form Detail. When form comes up in a display, the footer which has calulations appears to be at the bottom of the form. I have move the footer as much as I can to Form Detail. Please see the attach Thanks

Good point Pat, let me take a look at the aspect as well

This should be a no brainer for some people. I am trying to convert a excel formula to access. The column for h/c adj$ reads: =IFERROR(TRUNC(D1024*(F1024*G1024/E1024-G1024),2),0) Col: D1024 E1024 F1024 G1024 qty: act h/c: std h/c: rate: h/c adj$: detail: 14.00...

I have several different subforms, I have field adding several Textfields in the Form Footer. Now I need to combine all the subforms into one main form and do a summary. I know you can do it in reports such as using the "HasData" method. I could not make it work. Any ideas on how I can make...

Being from Kansas. Get away from KC and head west on I-70. Go to Salina, one of the best places to eat hamburger Cozy Inn. Stop in Abline be for Salina, great old west town.