🙂 I really appreciate these comments.

I learn a lot from them.

Yes, by temp I mean staging tables.

Thanks again for help.

DD

Thanks a lot!

This definetly helps. I will let you know if I have any other questions!

DD

Thanks for the reply. I am sorry but I am not sure that I understand your answer. Could you please give me more details? Am I at the right track...

This is great!!!! It gives exactley what I was looking for.

Now I have to look in detail and try to understand 🙂

Thank you one more time

Thanks to all for so fast replies!

The last one by Mark seems to be the closest to what I need.

I already have a table that has a same structure as...

Thanks for all your input.

I will post back once I decide the way I will do it.

This was very helpful!!!

It seems I am at the right track.

What I do up to now is:

I build @whereClause in my front-end application (access 2007) which I send to...

Thanks for input.

I have read a lot about dynamic SQL, but I still have not found a single example that would do something similar to this. In most cases the...

Hi,

Yes this works with this statement.

But I modified mine alittle bit so it looks like something like:

SELECT DISTINCT ([ContactID]) AS myContact

FROM tblContact

WHERE ([City]) In ("Toronto","Vancouver")

GROUP BY [ContactID] HAVING...

Hi ,

one more question.

Let's say we have:

ID ContactID City

1 1 Toronto

2 1 ...

Liebesiech:

Yes this would give desired result.

Thanks for advice!

Uripedes Pants:

Yes I have combo boxes. I also allow user to build his query that I store in a temp table. Then...

Hi,

Thanks for your answer. I can see your point.

How would you manage this situation.

ID ContactID City

1 ...

Thank you for response.

Would you mind giving me a SQL stored procedure example that would handle this?

Right now I am building my SQL statement on the front end, and I...

It worked !

Thanks a lot!

Thanks for the input!