Microsoft Access Expression Builder Help

[brian2008]

I am an electrical superintendent. I built a database to track a job. I made a database of all cables/circuits we have to install. My table consists of the entire project, then I created queries to break it out by areas. Each circuit contains 5 "Yes/No" columns (Conduit Complete,Wire Pulled, Wire Tested, Wire Terminated and Conduit Labeled). I made a report per area to tell me percentage complete per column. Right now it wants to give me a report of each circuit but I would like on 1 report the 5 items we are tracking to have 1 total percent complete. Example: Conduit Complete 50% (50 out of 100 circuits conduit complete columns were checked yes after they were completed) This will be something we can check daily and get an updated percentage complete daily.

I hope I explained this well enough for someone to understand and I definately appreciate any help.

Thanks,
Brian

[Jerry Maiapu]

If I can understand you properly then try This:

On the Report Footer (Not Page Footer),
count the no of YESs for each column:

For example to count get the total no of YESs in Wire Tested column,

txt1:

 =Sum(IIf([Wire Tested]="Yes",1,0))

Now calculate the total Yes& NOs

txt2:

=Count([Wire Tested]

Now get the percentage for all the Yes of the total:

txt3:

=(txt1/txt2)*100

Do the same for the rest of the columns:

NB: You can set Visible=No for txt1 and txt2 if you do not wish to view so that the percentage in txt3 is only viewable.

Cheers

Hope this helps

Jerry