Records not showing in pivot table

[ericarennie]

Hi, I hope someone can help me. I have a database as thus:

Several tables ->appended together using 'union select' into a query called 'sheet1'-> information that is coded converted via linked tables in a query called 'sheet2'

'Sheet 2' looks completely fine - it works dandy but when I try and run a pivot table not all of the values in one column that should show don't even come up as an option.

The values that are missing on the pivot report do actually exist in the query that it is running from.

There are no filters on and Pivot tables work okay on the origional tables.

Has anyone had anything similar?

Help would be most appreciated,

Thanks,

Erica

 

[neileg]

Try appending your union query to a new table and run the pivot on that just to make sure there's nothing odd about the data.