Problem with Query and pivot table

[winterh]

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.

[winterh]

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));