InfoPath Dev

Hallo @all,

I want to do a query and i got a colloum called years. Now I want my repeating table to show all entries with 2008 or 2009. How could I manage to do so??(Excuse my bad English). What do I need to enter in the QueryField for the years coloumn?

Thanks a lot and I hope you do understand what I mean.

Greetings Basti

Hi,

In the Data Connections go to "Edit SQL" and give the following query:

select "year" from "dbo"."TableName" as "TableName" where "year" in (2008,2009).

Thanks! Well, now I get all out of the years 2008 and 2009 but cant filter anymore. (Well, exactly what the SQL-Query does do!)

Any other solutions?

Greeting