Matching patterns

[Markster]

Hello,

I'm a little lost with this one and unfortunately I haven't done much in access for a while.

A client wants to match trends in a stats database.

I'll try and give you an idea below what is required.

Stats are recorded in a main table as below.
He wants to key in a few numbers that return matching results.
So if he was to key in 2,1,2,2 (probably into a form) everything from line 3 down should appear to show future trends. I was thinking a loop to go through the recordset and find any matching patterns but I'm unsure how to match the multiple criteria..

Data table

1
1
2 - from this line down
1
2
2
1
2
2
1

I hope this makes sense, any help would be greatly appreciated.

 

[Trevor G]

Will the table have an ID field which uses an autonumber? Your example doesn't really help, but you could use a query based on the id number, or if just using a table, then look to use a filter based on a criteria.

It may help if you could state which version of MS Office you are using.

 

[dkinley]

What you would want to do is probably do some searches on quantitative evaluation of frequent pattern mining algorithms. Basically what that means is that you are going to mine numerical data looking for patterns in the data that occur with regular frequency.

The distinction in your case, is that you will be looking for a specific case of patterns as opposed to trying to sift data or come up with a predictive algorithm.

My old text books are stored in a box or could probably point you to some specific algorithms (e.g., Boyle-Moore for text patterns) but you should find plenty of this information documented from master and phd students out there. They should have tested their hypothesis in SAS or C which should be published with the paper, so it should be able to provide a basic construct to what the code would look like in VBA.

Sorry I am not much more help - but hope that is some guidance in the right direction.

-dK

 

[Markster]

Thanks for the reply.

I haven't created the table as yet but I always include an id as an autonumber.

I'm using Office 2007. Tomorrow I might create a sample database to try and make it a bit clearer on what I will have to try and achieve.

 

[Markster]

Thanks Dkinley, I'll do some googling on that. I did try googling patterns, multiple criteria etc.. but couldnt find what I needed.