Search results

Hi I am using Access 2002 SP1 and have created a pivot table based on a query which works fine. However if I change the structure of the underlying query by adding another field, the field is not availabe in the Field List in the pivot table. I have used the refresh option but I understand it...

I am not sure if you ever solved your problem but in the pivot table Properties under the Behaviour tab there is a Hide/Show Drop Areas tick box.

Report Thanks for the suggestion. Although I am using Access 2003 the database is in Access 2000 format, sorry I did not make that clear. I have looked at the report properties and there are more properties in the report in the 2000 version on my PC rather than the 2000 version on the other PC...

Hi I am using Access 2003 and have created a report which uses Sorting/Grouping and works fine in 2003. When users open the same report in Access 2000 (SP3) there are various fields missing on the report. For example in the group header section the address fields do not display but the name...