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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: kerrycharnley
- Content: Threads
- Order by date
-
Access 2002 Pivot table. Decimal numbers incorrect
Hi, Please help anyone!!! I have created a Pivot table in Access 2002. Some of the data is decimal numbers less than 1, but the pivot table insists on rounding it down to 0. eg 0.60 is shown as 0.00. If I look at the table in Datasheet view, all the data looks correct How can I stop this from...- kerrycharnley
- Thread
- Replies: 1
- Forum: Microsoft: Access Tables and Relationships
-
Need to show multiple query results in one field
Can anyone tell me how to do the following, I have an access database that I need to create queries in. I am getting duplicate results when running a query because some of the Companies I have listed, have several ID's selected. Is there anyway I can get the query to show the company once, and...- kerrycharnley
- Thread
- Replies: 10
- Forum: Microsoft: Access Queries and JET SQL
