Pass Yes/No Values from Parameter Screen to Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a parameter screen which allows the user to select a value 'Yes/No'
for one of the select criteria for a query underlying the report. How do I
write the SQL for the query to accept the value from the parameter screen?
What datatype should it be?

This is what I have, but the Microsoft Jet database engine doesn't like it...

PARAMETERS [Forms]![TM_Run_TEST_Item_Report]![SysRelated?] Binary;
SELECT [1_All Data].*
FROM [1_All Data]
WHERE ((([1_All Data].[Identified by]) Not In (2,6))
And (([1_All Data].[Follow-Up Completed?])=True)
And (([1_All Data].[Follow-up Requirement])<>6)
And (([1_All Data].[Lawson or System
Related?])=Forms!TM_Run_TEST_Item_Report![SysRelated?]));

Can you help me?
 
Back
Top