Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » Data in queries
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Data in queries
Resolved · Medium Priority · Version 2003
Reply
Data in queries
When trying to produce a pivot table from a query, it is not displaying the correct information.I have a main table that looks up a list of data from a separate table ( a list of our sites and premises). The list is very basic, only an ID coloumn and the site name. When I run a query, it displays the site name perfectly. When I put the query into pivot table view, it displays the site's ID rather than it's name. How do I stop this?
For upcoming training course dates see: Pricing & availability
RE: Data in queries
Hi Rick, thanks for the query. Need a bit more information about this. Am I right in thinking you're generating a new table through a query to the sites & premises table, and then with that data creating a Pivot table? I think this might be where the problem lies. A two field table turned into a Pivot table doesn't yield a lot in the way of extra functionality!Also, are you dragging the correct field onto the Pivot table. Have you tried adding extra fields/dummy data into your source table and generating a Pivot table from that? When you get that to work, just delete out the source data.
Hope this helps. Do get back if you need more assistance.
Anthony
Wed 21 Oct 2009: Automatically marked as resolved.
|
 |
|
» Forum post: Sorting by date |
I have a schedule with a column for dates.
