Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pivot losing precision

Status
Not open for further replies.
MrsMope

MrsMope

Technical User
Oct 18, 2004
125
US
Hi,
I have a pivot form in access 2002, there is a field called WB_TIER that has values ranging from .08 to .00008, when I pull the field into the pivot, the only option is '0', how can I keep the precision on this field when it is pulled into the pivot form?
Thanks,
RB
 
Sort by date Sort by votes
Well,
I decided to just make the field a text field, then I don't lose the formatting, if anyone has a better idea let me know.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

newguy86
  • Locked
  • Question
Pivot Table Report
Replies
3
Views
160
dhookom
dhookom
billheath
  • Locked
  • Question
Pivot Table chart in form
Replies
1
Views
91
dhookom
dhookom
CWalsh87
  • Locked
  • Question
Pivot Table: Filter from Array
Replies
0
Views
57
CWalsh87
CWalsh87
kennedymr2
  • Locked
  • Question
Pivot Table Access 2010
Replies
1
Views
47
kennedymr2
kennedymr2
4N6Mstr
  • Locked
  • Question
Pivot Form: do they fire events?
Replies
1
Views
70
4N6Mstr
4N6Mstr

Part and Inventory Search

Sponsor

Back
Top