If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Unpopulated Fields in a Form based on Pivot tables
I use Pivot tables to view sales by month Jan-Dec, but can't seem to find a
way for the form (or report) to automaticaly deal with the fact that in February there are no pivot table fields for the months March through December. Each month I have to manualy go through various forms and reports adding the new field for that month, or I create all the fields ahead of time and set the fonts to white so they don't show the error condition. Surely there is a better way to deal with this and I have just not found it. Any help would be appreaciated. Thanks, John Pierce |
Thread Tools | |
Display Modes | |
|
|