This is the forum to discuss the Wrox book Access 2003 VBA Programmer's Reference by Patricia Cardoza, Teresa Hennig, Graham Seach, Armen Stein; ISBN: 9780764559037
You are currently viewing the BOOK: Access 2003 VBA Programmer's Reference section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
Count of wrkordno status
EmployeeName B/forward C/Forward complete Grand Total
Jackson S 282 1 284
Jambaya F 405 405
Katchisie 77 77
Petros J 508 2 1 511
Sithole F 1000 1 1002
Grand Total 2272 3 2279
I have designed a pivot table in access like the one above but the problem which i have now is that i want to add a calculated field which is calculated as follows perf=(B/forward+C/forward)/Grand Total
Excell only give the fields imported from access which are employeeName,WorkOrderNo and Status(Status having the following, records B/forward C/Forward and complete )
how to added a calculated field in pivot table
Linear Mode
