Results 1 to 2 of 2
  1. #1
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110

    Problem with Query and pivot table

    Hope you can help….
    I have two tables one which included all my users and asecond table which has a drop down using the names on the first table, and onany forms the drop down displays the names.
    When I run any query using the information on the drop downI have to us the ID number eg 3 but if I put the name of the user eg “ash” itdoes not return any information.


    So when I try and design a pivot chart the chart displaysthe user as 3 but I need it to show the name or have some type of key whichwill display both.
    Please help this is my last job before the thing isfinished.

  2. #2
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110
    If it helps I have enclosed a copy of the SQL below, on drop down the box show the name "Ash" and in the query it show the name "ash", but as you will see below it using the ID number for the name and not the text.

    SELECT MainData.ID, MainData.DateFirstLetter, MainData.[Multi Claim], MainData.LIveCase1, MainData.TotalNoPPi, MainData.NoPPI1, MainData.NoPPIDate1, MainData.NoPPI2, MainData.NoPPIDate2, MainData.NoPPI3, MainData.NoPPIDate3, MainData.NoPPI4, MainData.NoPPIDate4, MainData.NoPPI5, MainData.NoPPIDate5, MainData.NoPPI6, MainData.NoPPIDate6, MainData.SalutationClient1, MainData.[2nd Name Client1], MainData.[Salutation Client2], MainData.[Salutation Client2], MainData.ComFigs, MainData.AgentDropDown, MainData.ClientStatus2
    FROM MainData
    WHERE (((MainData.AgentDropDown)=1));

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Pivot Table from Query to Form
    By polpolpol in forum Forms
    Replies: 0
    Last Post: 03-20-2012, 12:11 PM
  2. Replies: 1
    Last Post: 12-18-2011, 01:28 AM
  3. Query default to Pivot Table view
    By Theremin_Ohio in forum Access
    Replies: 1
    Last Post: 03-30-2011, 09:17 AM
  4. Replies: 0
    Last Post: 06-06-2010, 08:23 AM
  5. Pivot Table Problem
    By larpup in forum Forms
    Replies: 0
    Last Post: 01-06-2006, 08:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums