Recent content by Cbell5

Perfect! Thanks for all of your help!

Thank you vbaInet! Both of the links you provided are very useful. I got that to work! Now that it is pulling in the proper names I have to figure out how to get the rich text to appear in the column heading properly instead of this (<div><u>Call Log</u></div>). Any ideas? Thanks

Thank you for the link. I understand much better how to create an SQL in VBA now. How would I construct the names as aliased fields? Would I have to do it for each question or would it do it for me?

I have a crosstab query that looks like this: SupervisorName EmployeeName NumberofCalls 17 18 19 Michael Jordan Scottie Pippen 3 5% 10% 5% Joe Montana Jerry Rice 7 6% 10% 8% I need to create a report from the crosstab query that is...

Bob, I appreciate your assitance on this one. Maybe I could bounce an idea off you to see if this would work better. I would rather not have to export any data to Excel, and just create a report in Access. The managers of the call center that I work for need to know how employees are doing...

Bob, Here is a copy of my database. The queries you are working with are: 1. qryCallCount (underlying query) 2. qryReport_All (crosstab query) The form used for the data will automatically load. Attached an excel workbook named VPReportTest.xlsm. (The workbook is blank though.)

I will get a copy for you and post it.

In the underlying query I have placed the parameters and have removed them from the main crosstab query. I have the parameters declared in the underlying query and in my crosstab query. I still receive the same error as before. "Too few parameters. Expected 2." Any thoughts? You are...

Bob, I added the code for both in their proper places that you gave me. When I click the button to run the code I receive an error which says, "Too few parameters. Expected 2." Could it have something to do with my actual query or what do you think would cause the error? Here is the SQL...

Bob, I am using your function. I am quite new to VBA and the modifications I made were what I thought I should do to pull my information using your Function. So with your function what should I be doing so that I can call my query (qryReport_All) and export it to the spreadsheet (RawData)...

Hello All, This is my first post on the forum. I need assistance with this bit of code. My end result will be a complex crosstab query that is exported to Excel. I believe I have the proper coding for this in a Public Function. I want to call the function with a commandbutton. Here is the...