Search results

I'm thinking of using the partNbr throughout parent-children-grandkids. Let me set up something as an example and see if it works at all.. Update: Oooo.. just realized something... hang on.. it ~is~ a little trickier. I see what you were trying to tell me now. Any thoughts? I uploaded a...

I’m thinking about writing a new access project. The application is collecting inspection data, and although I might be better served doing this in excel – I’m willing to look at it as a database concept first. What I see are essentially three tables: tblPartInfo, tblDataReqs, and...

Good deal. (It's good to be helping someone instead of asking for help.) Glad it worked out.. :cool: .. (Now if we can just teach you how to spell.. ).. :D

Avg: (IIf(IsNull([Val1]),0,[Val1])+IIf(IsNull([Val2]),0,[Val2])+IIf(IsNull([Val3]),0,[Val3]))/(IIf([Val1]>0,1,0)+IIf([Val2]>0,1,0)+IIf([Val3]>0,1,0))

You never told us that you had zeroes, you said you had null. Change the denominator "(IsNull([Val1])" to something like " ([Val1]>0)"

The screenshot is in the thread. Take a look for yourself. I used your same exact data. I will upload the database even. By the way, that's TownDawg, not Town Dog.

Re: Calculating the average of 3 fields Can you post a sample of your db? Something is wrong, because as you can see -- the expression I posted (with screenshot) worked fine.

Re: Calculating the average of 3 fields Avg: (IIf(IsNull([Val1]),0,[Val1])+IIf(IsNull([Val2]),0,[Val2])+IIf(IsNull([Val3]),0,[Val3]))/(IIf(IsNull([Val1]),0,1)+IIf(IsNull([Val2]),0,1)+IIf(IsNull([Val3]),0,1)) SELECT tblMath.ID, tblMath.Val1, tblMath.Val2, tblMath.Val3...

Have you incorporated the Nz() function into your expression?

Are you saying that when there is a NULL value, (in your second example) that your expression returns 200/3?.. instead of 200/2?

I was just trying that out.. :).. It was sOoo much easier than I thought it would be. WHERE (((rptDataEntry.Defect_ID)<>99) AND ((rptDataEntry.Dispo_ID)<>"UAI") AND ((rptDataEntry.[RSK])<>"1")) OR (((rptDataEntry.Defect_ID)<>99) AND ((rptDataEntry.[RSK])="1")) Thank you sir.

I'm not sure if you can do this or not?.. In essence a conditional criteria. There are three types of audits: QA, QC and Int (Internal). On the report, my boss wants to see all of the audit findings (including UAI, "use as-is") IF the AuditType - "QA", but does not want them included IF the...

Oops.. revised the SQL. SELECT qryDataEntry.Defect_ID, qryDataEntry.Series_ID, qryDataEntry.SeriesDesc, qryDataEntry.QtyRejected, qryDataEntry.SO_Nbr, qryDataEntry.AuditDate, qryDataEntry.Comments, qryDataEntry.Dispo_ID FROM qryDataEntry INNER JOIN tblDefects ON qryDataEntry.Defect_ID =...

Right now my SQL for a similar issue is this: SELECT qryDataEntry.Series_ID, qryDataEntry.SeriesDesc, qryDataEntry.QtyRejected, qryDataEntry.SO_Nbr, qryDataEntry.AuditDate, qryDataEntry.Comments, qryDataEntry.Dispo_ID FROM qryDataEntry WHERE...

It's the south. It gets hot. All good southerners know that Spring and Fall are for outdoor activities. Just because they have the "Memphis in May" celebration when it's hot doesn't mean it's the best time to visit. ;)

As usual, you are amazing. Thank you! * clicks on pbaldy's reputation counter *

This one is similar to the stated problem -- I just don't see what is wrong yet? New query called rptDataEntry without filter: (works fine) SELECT qryDataEntry.Defect_ID, qryDataEntry.DefDesc, qryDataEntry.AuditorType, Sum(qryDataEntry.QtyRejected) AS SumOfQtyRejected FROM qryDataEntry GROUP BY...

Thank you! .. (but what I really needed was this one.) http://www.access-programmers.co.uk/forums/showthread.php?t=145447 Specifically this: Private Sub YourTextControlName_AfterUpdate() If Not IsNull(Me.YourTextControlName.Value) Then YourTextControlName.DefaultValue = """" &...

Thank you sir. That link is exactly what I needed.

This is very easy I am sure, but I just don't know how to do it. I have searched the threads and do not find exactly what I am looking for. Entering data into a form. The first field is basically "who". When that data is entered, the "who" stays the same until there is a new "who". Glancing at...