If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
using access to filter data
bad title but...
I have a huge amount of data in Excel that I am sorting by instances. Example: I have a unique ID field, and any ID that have multiple instances, that is, more than one line item, I must copy into a separate worksheet. Is there a way that an Access database can perform this function more efficiently? There are over 7000 lines of data and it is taking an inordinate amount of time to complete. Thanks for your help. -- APM |
#2
|
|||
|
|||
using access to filter data
On Tue, 14 Oct 2008 11:40:01 -0700, annipy
wrote: bad title but... I have a huge amount of data in Excel that I am sorting by instances. Example: I have a unique ID field, and any ID that have multiple instances, that is, more than one line item, I must copy into a separate worksheet. Is there a way that an Access database can perform this function more efficiently? There are over 7000 lines of data and it is taking an inordinate amount of time to complete. Thanks for your help. Trivially easy in Access, with a Query: SELECT [ID] FROM Table WHERE Count(*) 1 GROUP BY ID; With a 7000 row table you'll get the result before you can blink. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
using access to filter data
Thanks John. I'll try it.
-- APM "John W. Vinson" wrote: On Tue, 14 Oct 2008 11:40:01 -0700, annipy wrote: bad title but... I have a huge amount of data in Excel that I am sorting by instances. Example: I have a unique ID field, and any ID that have multiple instances, that is, more than one line item, I must copy into a separate worksheet. Is there a way that an Access database can perform this function more efficiently? There are over 7000 lines of data and it is taking an inordinate amount of time to complete. Thanks for your help. Trivially easy in Access, with a Query: SELECT [ID] FROM Table WHERE Count(*) 1 GROUP BY ID; With a 7000 row table you'll get the result before you can blink. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
using access to filter data
"annipy" escreveu na mensagem ... Thanks John. I'll try it. -- APM "John W. Vinson" wrote: On Tue, 14 Oct 2008 11:40:01 -0700, annipy wrote: bad title but... I have a huge amount of data in Excel that I am sorting by instances. Example: I have a unique ID field, and any ID that have multiple instances, that is, more than one line item, I must copy into a separate worksheet. Is there a way that an Access database can perform this function more efficiently? There are over 7000 lines of data and it is taking an inordinate amount of time to complete. Thanks for your help. Trivially easy in Access, with a Query: SELECT [ID] FROM Table WHERE Count(*) 1 GROUP BY ID; With a 7000 row table you'll get the result before you can blink. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|