Search results

I'm running into a bear of a problem... My table contains lots of survey data, and looks simular to: Table: tblData Agent_ID Agent_Name Group_Name TimeStamp Avg_Score 12345 Kyle Team3 1/1/05 8AM 2 12345 Kyle Team3 1/1/05 9AM 3...

My database contains thousands of quality surveys, each with 5 Questions. I have a query which groups by agent name so i can find out the average for each rep, including the average for each question and the new field to average all 5 Questions. I'm now working on a report to show this data...

So, thanks to all the great insight on this board I have gone from a complete access newbie to having pieced together what could be a pretty great database to track our quality scores... While the macro I have put together works in pieces, when I try to run the full 18 loops that are needed it...

I'm running some code to open up an excel book and clean it up before importing into access. This code works fine in a module, but is giving me some problems when I try to put it in the form and attach it to the button. I'm getting "The expression you entered contains invalid syntax" with...

I am trying to write some code to import some excel books into a table. The book needs to be heavily edited before it can be imported, and I have accomplished all of that, but I'm having trouble with the line that actually imports the worksheet into my table. Here is what I have: Sub...

Ok, I feel pretty stupid asking a question that has been asked so many times, but I've been searching on and reading this board all afternoon and something just isn't clicking for me. I started with This Thread to learn how to do an awesome calendar and link it to my query to run a report...