Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Query not returning correct results?!
Hello,
I have a table EmployeeID Assignmentment 1 6 1 7 2 5 The criteria range is EmployeeID Assignment 2 The CopyTo Range keeps showing EmployeeID Assignmentment 1 6 1 7 2 5 Why?!! It should show: EmployeeID Assignmentment 2 5 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Query not returning correct results?!
Perhaps I am missing something but what are you talking about??? Are you
using formulas or are you doing an external query. Is your query parameter driven. If it is an external query post your SQL. If it is a formula post your formula. -- HTH... Jim Thomlinson "Webtechie" wrote: Hello, I have a table EmployeeID Assignmentment 1 6 1 7 2 5 The criteria range is EmployeeID Assignment 2 The CopyTo Range keeps showing EmployeeID Assignmentment 1 6 1 7 2 5 Why?!! It should show: EmployeeID Assignmentment 2 5 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Query not returning correct results?!
You could be missing something or I was not clear enough:
1) I have a worksheet 2) I am using the Advanced Filter to copy values from my table to a "copyto" range. 3) The table is located in Columns a b 4) This is supposed to be a basic spreadsheet query (using the advanaced filter). Hopefully that clarifes it for you. Tony "Jim Thomlinson" wrote: Perhaps I am missing something but what are you talking about??? Are you using formulas or are you doing an external query. Is your query parameter driven. If it is an external query post your SQL. If it is a formula post your formula. -- HTH... Jim Thomlinson "Webtechie" wrote: Hello, I have a table EmployeeID Assignmentment 1 6 1 7 2 5 The criteria range is EmployeeID Assignment 2 The CopyTo Range keeps showing EmployeeID Assignmentment 1 6 1 7 2 5 Why?!! It should show: EmployeeID Assignmentment 2 5 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Query not returning correct results?!
That is an advanced filter and not a query... In any case... it works for me.
My best guess would be your criterai range is not set correctly. Make sure that the column header is included as part of the cirteria range. Otherwise the filter will not know which column the filter applies to. Here is what I have. Your original table in Cells A1:B4. The criteria is in cells D1:D2 and looks like Employee ID 2 My Copy to Range is F1:G1 -- HTH... Jim Thomlinson "Webtechie" wrote: You could be missing something or I was not clear enough: 1) I have a worksheet 2) I am using the Advanced Filter to copy values from my table to a "copyto" range. 3) The table is located in Columns a b 4) This is supposed to be a basic spreadsheet query (using the advanaced filter). Hopefully that clarifes it for you. Tony "Jim Thomlinson" wrote: Perhaps I am missing something but what are you talking about??? Are you using formulas or are you doing an external query. Is your query parameter driven. If it is an external query post your SQL. If it is a formula post your formula. -- HTH... Jim Thomlinson "Webtechie" wrote: Hello, I have a table EmployeeID Assignmentment 1 6 1 7 2 5 The criteria range is EmployeeID Assignment 2 The CopyTo Range keeps showing EmployeeID Assignmentment 1 6 1 7 2 5 Why?!! It should show: EmployeeID Assignmentment 2 5 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Query not returning correct results?!
The headers were fine.
I noticed that the criteria range included an extra line. Instead of DA1:DA2, it was DA1:DA3. This blank row, of course, was causing everything in the table to be returned. I made the criteria range DA1:DA2 and it is working fine. Tony "Jim Thomlinson" wrote: That is an advanced filter and not a query... In any case... it works for me. My best guess would be your criterai range is not set correctly. Make sure that the column header is included as part of the cirteria range. Otherwise the filter will not know which column the filter applies to. Here is what I have. Your original table in Cells A1:B4. The criteria is in cells D1:D2 and looks like Employee ID 2 My Copy to Range is F1:G1 -- HTH... Jim Thomlinson "Webtechie" wrote: You could be missing something or I was not clear enough: 1) I have a worksheet 2) I am using the Advanced Filter to copy values from my table to a "copyto" range. 3) The table is located in Columns a b 4) This is supposed to be a basic spreadsheet query (using the advanaced filter). Hopefully that clarifes it for you. Tony "Jim Thomlinson" wrote: Perhaps I am missing something but what are you talking about??? Are you using formulas or are you doing an external query. Is your query parameter driven. If it is an external query post your SQL. If it is a formula post your formula. -- HTH... Jim Thomlinson "Webtechie" wrote: Hello, I have a table EmployeeID Assignmentment 1 6 1 7 2 5 The criteria range is EmployeeID Assignment 2 The CopyTo Range keeps showing EmployeeID Assignmentment 1 6 1 7 2 5 Why?!! It should show: EmployeeID Assignmentment 2 5 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter returning complete database not filtered results | Excel Worksheet Functions | |||
Vlookup not returning correct value | Excel Worksheet Functions | |||
MAX Function not returning correct value | Excel Worksheet Functions | |||
VLOOKUP not returning correct value | Excel Worksheet Functions | |||
Vlookup not returning correct value | Excel Worksheet Functions |