Creating a query that returns (one / multiple) records from two parameters

Creating a query that returns (one / multiple) records from two parameters

Post by darob » Sat, 11 Mar 2006 05:31:08


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.
 
 
 

Creating a query that returns (one / multiple) records from two parameters

Post by Jeff Boyc » Sat, 11 Mar 2006 06:20:58

If you are working in InfoPath, I'd think posting your question there would
be more likely to find folks who can help. This is a Microsoft Access
newsgroup.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 
 
 

Creating a query that returns (one / multiple) records from two parameters

Post by Dan » Sun, 12 Mar 2006 01:58:35

Sorry about that. Wasn't sure if it was a error on my part when i wrote
the query in Access.