Crosstab: multiple records from filter

M

Melanie O

I set up a crosstab query using the Query -> Parameters to define the filter
on my query. When the query is run, it only returns one record (but I know
that more than one record should show up). If more than one record meets the
parameter criteria, how do I get all records to show on my form? The SQL for
the query is below.

Thanks,
Melanie

PARAMETERS [Forms]![frm_Paula]![SubProcess_ID] Long;
TRANSFORM First(tbl_ImpactReal.Value) AS FirstOfValue
SELECT SubProcess.SubProcess
FROM tbl_Category INNER JOIN (SubProcess INNER JOIN (tbl_LMSN INNER JOIN
tbl_ImpactReal ON tbl_LMSN.ID = tbl_ImpactReal.Value) ON
SubProcess.SubProcess_ID = tbl_ImpactReal.SubProcess_ID) ON
tbl_Category.Category_ID = tbl_ImpactReal.Category_ID
WHERE (((SubProcess.SubProcess_ID)=[Forms]![frm_Paula]![SubProcess_ID]))
GROUP BY SubProcess.SubProcess, SubProcess.SubProcess_ID
PIVOT tbl_Category.Category;
 
D

Duane Hookom

Try temporarily change your crosstab to a simple select query (no totals) to
see how many records you return.
 
Top