Search results

jdraw That could work but I am using a form for the query and I think my typo earlier screwed people up. That being where the pattern is always incremental instead of completely random. I may only know random pieces of the pattern and thus have to search by that (eg 8/12)but the table has the...

ok I think I understand the question. So if I have the patterns 7/8/10/12 8/12 8/10/12 7/12 I want to be able to run a query where if I only know 8/12 it will return 7/8/10/12 8/12 8/10/12 but will not return 7/12. the numbers in the table will always be in order, 8/7/12/10 should have read...

CJ I will try that out tomorrow when I get back to the database Mark as far as how the data is stored, as the data is an individual pattern on the crocodile it is stored in one table under the column S in this case there would be an individual with the scute clip pattern 8/7/12/10. Problem is...

Title should say NON sequential numbers Hey all, I am trying to figure out how to get my query to search for numbers that are not in sequential order and are separated by a "/". A little background: The database I am working with is for searching crocodiles that are marked with an external...

Hi everyone! I have come to this forum many times and piggybacked on some answers which have answered some of my own. I have been using Access for about a month and this forum has helped me out greatly. About me: Im a biologist and my interests revolve around gaming and science as well as the...