Cluster or correlation algorithm with large table

[freak11]

Hi guys,
I have got a large microsoft access table with around 4 million rows. These 4 million rows are grouped in such a way that every 60 row one specific group is formed.

I need an algorithm that allows me to search for a specific group that has similar rows to the search query. The search query will be always 60 rows.

Does anyone have any ideas?

thanks

[alansidman]

How data is stored in a table is not relative in a database. You accumulate, filter and sort data through criteria in key fields in queries and reports. Trying to extract data by location in a table is not viable. Perhaps you should give us more information about your table and the specific data you wish to group and then we may be able to offer up a solution.

Storing data in a table in particular manner is a spreadsheet concept and not a data base concept. You need to let go of the spreadsheet concepts when working with databases.

[freak11]

I would love to upload an example but I cannot upload files from microsoft access to this forum. Is there a reason why?

[alansidman]

You can. Here is how. Run a compact and repair. Then run a zip program to zip and compress the file. Upload the zipped file. Do not try to upload the whole file as it may be to big for the forum. Select a representative sample to include.