Recent content by StevieRayB

Hi Gemma, I tried, but never got it to recognize the separate spreadsheets, so I implemented plan "B" - get the requestor to simply get the data to me on individual workbooks and finish the automated load via entering the needed parameters on a form touching off a macro. Thanks for the help and...

I'll give it a try on Monday. Thank you!

Hi all; I have an Excel workbook that has 2 worksheets named "decision" and "quality". I need to load these 2 worksheets to Access into 2 seperate tables named (you guessed it) "decision" and "quality". I have a form that builds the path and filename portion of the macro to execute the...

The final result for all 10 quality columns. I made a "Time" master table with 2 columns, TimeA and TimeB joined by "Rep" to "TableA". Thanks again for guiding me. SELECT [TableA].ID, [TableA].REP, [Time].TimeA, [Time].TimeB...

CameronM, THANKS!!!! This works perfectly! We're actually preparing for a study. The logic for the columns are example quality scores, assigned to different call representatives for targeted times to complete a customer call for the study. For the example data, Rep 1 will have target times of...

Hello, Please see the attached WORD file. I need a query that selects data from "variable columns", and what I mean by that is in the attachment. I've placed the table, with sample data and the 2 desired query results in the attachment as they wouldn't display correctly in the preview...