Search results for query: *

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.

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?

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...

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...

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...

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...

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...

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.

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...

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...

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)

changed...no effect.

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] >...

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...

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

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?

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?