using access to filter data

A

annipy

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

John W. Vinson

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.
Click to expand...

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

annipy

Thanks John. I'll try it.
--
APM


John W. Vinson said:
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.
Click to expand...

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.
Click to expand...
 
Top