Data in queries

The UK's most regular instructor-led training courses.
Training information: access courses in london · Microsoft access courses · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Medium Priority · Version 2003

2 posts

ReplyTue 13 Oct 2009, 10:19Delegate 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?

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2007	Tue 3 Aug 2010	Bloomsbury	1		£215	£220	£235
2003	Fri 20 Aug 2010	Bloomsbury	7		£190	£195	£235
2007	Fri 27 Aug 2010	Bloomsbury	9		£180	£185	£235
2010	Thu 16 Sep 2010	Bloomsbury	7		£250	£255	£299
2007	Wed 29 Sep 2010	Bloomsbury	8		£176	£181	£235
2003	Fri 8 Oct 2010	Bloomsbury	10		£142	£157	£235
Full Schedule: See all 35 Access Intermediate course dates. Bookings currently available until 28th September 2011.

452 posts

ReplyWed 14 Oct 2009, 16:22Trainer 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.

Anthony

Wed 21 Oct 2009: Automatically marked as resolved.

· An Introduction To Queries In Access
· Why go on a Microsoft Access Training Course?
· Making Figures Talk For Themselves Thanks To Access
· How to Find a Third-Party Venue for Microsoft Access Training
· Access Corruption Avoidance Tip #3: Stay Connected

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

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips