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

  • Thread starter Thread starter darobe
  • Start date Start date
D

darobe

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)
From that I need a query or something that I can select something from
Click to expand...
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.
 
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
 
Sorry about that. Wasn't sure if it was a error on my part when i wrote
the query in Access.
 
Back
Top