Finding a range in an Infopath form

[Vangie]

I have an inforpath form that is connected to an Access database. Is there a
way to list the query fields so I can put in a range, for example, if I am
searching for only the records in a particular year or years? Or is there a
way to enter something in a field that could be part of a field and then use
a wild card, like *?

 

[S.Y.M. Wong-A-Ton]

If you want to use a wild card character, you'll have to write code. Search
this newsgroup to find samples on how to do this. This article
http://enterprise-solutions.swits.n...y-access-database-list-numbers&c=infopath2003
also contains part of the solution to writing the code for this.

Or you can do something similar to what I did in this article:
http://enterprise-solutions.swits.n...peating-table-date-range-rules&c=infopath2003
.. You needn't change your database, though, since you'll only be using the
year. Just alter the expression for the filter to only use the year.