data queries
Request a callback

We'll call during UK business hours

0207 987 3777

Forum home » Delegate support and help forum » Microsoft Access Training and help » Data in queries

Data in queries

resolvedResolved · Medium Priority · Version 2003

Tue 13 Oct 2009, 10:19 replyReply Delegate Rick said...

Rick has attended:
Access Intermediate course
Access Advanced course

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

Wed 14 Oct 2009, 16:22 replyReply Trainer Anthony said...

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.


Wed 21 Oct 2009: Automatically marked as resolved.


Please browse our web site to find out more about
access courses in london and other Microsoft training courses.

Access tip:

Pop up property

If you want to focus the attention of a form / switchboard to a user then you can change the propeties of a form/switchboard for Pop up to On.

This meand tht the focus for the user must be on the form / switchboard

View all Access hints and tips

Access training London
Course rating
4.8 stars - based on 4543 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom