H
honeybee
I have data that has been imported into access and when viewing the detail in
a database view (in the query) against the same data in the pivot view (in
the same query) the data does not match. It appears the data in the pivot
view sees the values only as an integer. For instance in the datasheet view
the value appears as .05 but in the pivot view the value appears as zero.
Why is this happening? how do I fix it?
a database view (in the query) against the same data in the pivot view (in
the same query) the data does not match. It appears the data in the pivot
view sees the values only as an integer. For instance in the datasheet view
the value appears as .05 but in the pivot view the value appears as zero.
Why is this happening? how do I fix it?