InfoPath Newbie Question/ Access Query

[vallecalle]

Hi all!

I'm testing the new office product Infopath 2003 and so
far i've made a simple form which is connected to an
Access Database.

The Database is very simple

ID
FirstName
LastName


So i've used the wizard to connect to the Database and
i've filled out the Query Form. Everyting is right so far.

Now I want to go further and my trouble is the following
one :

When I enter an ID existing in my Database , InfoPath
retrieve correctly the information, I was wondering if I
could make a request to ask not just one ID but for
example all the ID inferior to the ID filled in the Query
Form.

So when I enter 3 in my ID Textbox, how could I retrieve
all the previous ID for example not just the ID number 3?

(I'm looking to have an < in my SQL Request)

Is there a way to do that?

Thanks in advance.

 

[Cindy Meister -WordMVP-]

Hi Vallecalle,

You should post this question in the Infopath newsgroup.

I'm testing the new office product Infopath 2003 and so
far i've made a simple form which is connected to an
Access Database.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail