Creating a Query form that will return all records based on two parameters

Creating a Query form that will return all records based on two parameters

Post by Dan » Sat, 11 Mar 2006 05:33:55


I want to create a query in InfoPath 2003 that accesses Microsoft SQL.
What I want to happen is when I select a date and a facility that the
query will only return those records that are for that particular date
and for that facility.

So this is what I have:


tblAccounts
ID#
Name


tblAccessErrors
ID#
Date
Time
etc...(just more information about the error)



tblAccounts.Name and from tblAccessErrors.Date then have it return all
of the records from tblAccessErrors that match the date and the name of

the account.

I hope I'm not clear as mud. Thanks for any help you can provide.