Connecting Tech Pros Worldwide Help | Site Map

Query/Report Question

Randy
Guest
 
Posts: n/a
#1: Nov 13 '05
Whenever I do a query it works correctly on two fields when it is run
and brought up in datasheet view, but whenever I attached it to a
report it only brings up one parameter that I specified rather than two
that is in the query.

Any suggestions on what could be wrong?

pietlinden@hotmail.com
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Query/Report Question


what happens if you pass the Where clause of the query to the report
when you open it?

Randy
Guest
 
Posts: n/a
#3: Nov 13 '05

re: Query/Report Question



The parameter query is set up to bring up the case number and STARTDATE
and ENDDATE. It brings up the Case Number parameter, then it brings up
the STARTDATE parameter, then it brings up the ENDDATE parameter when I
just run the Query it runs fine when it is tested and brings up the
datasheet. When I attached it to the Report it only brings up the
STARTDATE parameter and the ENDDATE Parameter so I only get the data on
the report based on the latter.

I need it on the Case Number Parameter also.

The report is grouped by Worker then by Case Number and then by detail
that includes the DATE of the data I need to bring up.

Closed Thread