Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. StarhawkGamer

    Subscript out of range error

    The raw data is in excel and I'm using an excel-based converter to prepare the data to go into Access. I don't have access to the original SQL-based database to pull this data via SQL.
  2. StarhawkGamer

    Subscript out of range error

    Alright, my conversion is equation is =if(a2="Yes",1,if(a2="No",0,"")....how would I convert it to a null in the event of a D/K, N/A, or null in A2?
  3. StarhawkGamer

    Subscript out of range error

    yesterday, 2 tables were doing it, one that was a straight data pull and the other which went through the data converter first. Now, only the later one is doing it. Sorry about the confusion there. What can be done to correct those 4 columns so that they come through as number, even with the...
  4. StarhawkGamer

    Subscript out of range error

    That explains part of it....I'm converting the raw data from text to numbers so that I can average it in various reports. I convert "Yes" to 1, "No" to 2, and anything else, such as "DK" and "N/A" to a null space. There are 4 columns that "DK", "N/A", and null spaces are found in the original...
  5. StarhawkGamer

    Subscript out of range error

    Alright, I've got two problems that I'm facing with my Access database. The first is that it won't let me copy from Excel into Access via the clipboard (damaged clipboard error). I can work around this error via the data import system, but that has lead to a second issue. I've got some tables...
  6. StarhawkGamer

    Microsoft Query Parameter Problem

    I'm attempting to build a parameter query in MS Query to pull data from an Access 2007 database into an Excel 2007 spreadsheet. I have attempted every permutation of the between statement that I can figure out and either I get a "Too Few Parameters. 2 Expected." error or I get all of the data...
  7. StarhawkGamer

    Microsoft Query Error

    I'm attempting to build a parameter query in MS Query to pull data from an Access 2007 database into an Excel 2007 spreadsheet. I have attempted every permutation of the between statement that I can figure out and either I get a "Too Few Parameters. 2 Expected." error or I get all of the data...
  8. StarhawkGamer

    Mail Merge

    Both of these suggestions have been useful. In the end, the problem was easily cured just by copying the worksheet off of the macro-version (doing a paste value), sorting the affected columns, and deleting the contents of the blank cells, and then targeting the Mail Merge to the non-macro document.
  9. StarhawkGamer

    Mail Merge

    I'm attempting to do a mail merge with a Word 2007 document and an Excel 2007 Macro-Enabled Worksheet (*.xlsm) (using VBA to create statements based on information being reported). A couple of fields can either be a null/blank value or a numeric value. The problem I'm having is that the null...
  10. StarhawkGamer

    Tracking Changes

    I've got a database where I get records about agent performance. Part of the database includes who their supervisor is. I need to be able to track who their supervisor was on any given date or date range and assign only the records from the date(s) they were assigned to the supervisor to the...
  11. StarhawkGamer

    Getting last 10 records

    Thank you. It works perfectly!!! Made one change from doing it by date to doing it by survey ID# (because multiple surveys can be done on a single day)
  12. StarhawkGamer

    Getting last 10 records

    changed...no effect.
  13. StarhawkGamer

    Getting last 10 records

    tried those changes and still get a syntax error. here is the altered code. SELECT Agents.[Advocate ID], foo.[SessionID], foo.[FATAL IR] FROM Agents INNER JOIN QA as foo ON ( foo.[UNIT ID] = Agents.[Advocate ID] AND ( SELECT COUNT(*) FROM QA WHERE [UNIT ID] = foo.[UNIT ID] AND [SURVEY DATE] >...
  14. StarhawkGamer

    Getting last 10 records

    Ok, attempted to set it up and I keep getting a syntax error on the subquery. SELECT Agents.[Advocate ID], QA.[SessionID], QA.[FATAL IR] FROM Agents INNER JOIN QA ON QA.[UNIT ID] = Agents.[Advocate ID] AND ( SELECT COUNT(*) FROM QA WHERE [UNIT ID] = QA.[UNIT ID] AND [Survey Date] QA.[Survey...
  15. StarhawkGamer

    Getting last 10 records

    I guess I'm just not understanding the second select statement in the query. Could you explain the logic behind the line AND ( SELECT COUNT(*) FROM surveys WHERE agentID = s.agentID AND surveydate > s.surveydate ) < 10
  16. StarhawkGamer

    Getting last 10 records

    How would you change it if you were just doing it with the single table and getting the agent's ID to cross-reference in Excel?
  17. StarhawkGamer

    Getting last 10 records

    I have two tables, 1 has a list of agents, the other is quality control surveys for all agents. is there a way in Access to get the last 10 QAs for each agent in a single query?

Part and Inventory Search

Back
Top