Still too complex. As a few members here have said, when the query is too complex, stop cursing at the query and change the form behing it. Simplicity...

there's always a but .

I have 0 advanced maths formation... I'll let you handle this one .

Btw, my number of combinaison was only for different combinaisons of...

Is the table permanent or temps?? Have you tried using the other version?

Hey govinn, even with only 20 numbers, you have

2 432 902 008 176 640 000

different possible combinaisons of numbers.

That's 2.4 billions million combinaisons. Do you really want...

Can you connect to it??

Hehe. I've read a article with something like this a few days ago... was about a Whoops incident. Can't recall the circumstances

If it was for a prefix number of values, it could be done. but if the logic is find any match, with any qty of numbers, then I don't...

What fields need to be updatable in the form?

Just run my query and compare to yours... I'm just specualting on your needs. You know what you need more than me.

Please do not cross-post. I already answered that question here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=192379

Isnull is built-in. You can also lookup COALESCE.

Yes, but as I said, this is something that needs to be coded in some asp page. Or any web language. You need to find tutorials to do...

What do you mean by Access???

You can interact with a db with an asp page (or .net C#/ASP.net). But the access work is done on the server, not in...

You mean something like this??

SELECT

c.name

, O.id

, case when I.indid BETWEEN 1 AND 254 AND (I.status & 2048 = 2048 or I.Status = 16402 /*clustered + unique*/ and...