Avg With 0`s

[wilpeter]

You hadn't previously mentioned that it was the Hours you wanted averaged. If you've looked at the database attached to Post #20, you'll see that I thought it was Avg Cost you wanted...but I'm sure you can adapt it.

 

[B.A.M]

Really It Would Be All $ (Costs Averaged) For The Report
Im Close


Thank You For Your Support

 

[wilpeter]

Hello again. It's been about 20 hours since your last post and I'm wondering if you've opened my attachment successfully. Did it give you enough that you can now work on your own, or are you still waiting for something further--if so, what?

 

[B.A.M]

I Believe Iv Got It To "Acceptable"

Useing The >0 In Design Mode Under Criteria
It Will Work For ME Untill The Database Owner Shows Me How To Do The Same Without Hideing The Entrys With Zero Values

Thanks To All involved
Thanks To The Access World Forum
Thanks Again To All

I Did Manage a Back Button On The Applicable Forms
Now Its Just A Matter Of Haveing The Format Of Specific Critera On The Reports Request Form (For The 6 Reports Req)
AS Of Now Its 1 Long Form With Multible Options/Dropdowns
I Had Fri Off

 

[wilpeter]

I Believe Iv Got It To "Acceptable"

Useing The >0 In Design Mode Under Criteria
It Will Work For ME Untill The Database Owner Shows Me How To Do The Same Without Hideing The Entrys With Zero Values

I have the time and patience to continue, should you wish to take it to a higher level. Just in case: if I understand the quote above, the person who understands the problem showed you an alternative to the sub-query I used in my attachment last week. The "TblCombinedQuery" in that attachment displays both the Cost field and the CostNonZero field, so it does not hide any entries. Are you comfortable with converting this example to other fields that you wish to Average? I believe you do understand that it is the TblCombinedQuery that is the source for the Report.

Unfortunately for me, I am using 2003 version of Access, so am unable to run some of the features of your database that you attached. Even if you attach the form about which you are talking, I likely would have to hope someone else can open and help with it.

Let us know if you want further assistance.