Help in changing number value to text on report of combo box....

[drblackard]

I am using a combo box to enter Employees names for training hours...I want to use a pivotchart but when i use the training hours table/form the pivotchart gives me the combo box numbers instead of the names. I know there is a formula or something I am suppose to use here or even a query but I don't have a clue as to how to do this....if someone would be so kind in directing me with instructions and help...thanks

 

[Moniker]

Wow, you can always tell the Excel users that think Access is "advanced Excel".

A Pivotchart? Really? What is it you're trying to do in English terms, not Excel terms? You're getting the ID numbers associated with the employee names. Did you import the names from Excel and then have Access auto-assign a primary key? (That's my guess here.)

I seriously have no idea how a pivotchart would be useful in a table/form of employees, and I can be wrong, but I think you're thinking Excel and getting seriously confused by Access. I understand that you're trying to get to a chart of training hours, but I think you've gone far down the wrong path and need to rethink what's actually happening here.

If your chart is working fine and your just getting the number for an employee instead of their name, then you just change the column width properties of the combobox. Leave the bound column to the employee number as that's the key, but give it a column width of 0 so that it doesn't appear.

If I'm way off base, then I'm sorry, but your question wasn't worded well and I was going by experience as to what was really going on. Please elaborate more.

 

[drblackard]

Thanks for your comments...

No I actually am not an excel user but I guess I can take that as a compliment...I am using the PivotChart to try to force people to come and train on their jobs...a visual aid if you will....show others where you are on your training...it's just a prop....it is under the forms menu and I thought it to be a pretty cool thing to do/try...if it's a problem ... hey thats cool...it doesn't have to happen...however, I will look at excel but I really don't want to have to use to software programs to do this...all is well.....hope I made it clearer...thanks for your help

 

[Pat Hartman]

Use a query as the basis for the pivot chart. The query should join the main table to the lookup table and select the employee from the lookup table rather than the ID from the main table.

Moniker, Pivot tables and charts are just as much a part of Access as they are of Excel and just as useful.

 

[Moniker]

PivotCharts (and PivotTables) are perfectly viable in both applications, just not this particular situation (as far as I can tell). I think he's just trying to show a graph of who has done X amount of training, in which case, and especially in Access, a query is a way to go, with a chart based off of it. Pivoting data in this case is just obfuscating the subject (mountain out of a molehill type of thing).