Query Field beginning with 1/ 1

[netrusher]

In the code below the Process=1/* represents the field I am querying on. What I am trying to do is Sum Forms where the Process field begins with 1/. I do not have the option of changing the names of data that populates the Process Field. The Engineers have named the Processes and they either begin with a 1/, 2/, or 3/. Can anyone tell me how to set up the criteria that will Sum the forms based on the Process name beginning with a 1/? I tried using 1/* but that did not work?

SELECT 
Sum(IIf((Process=1/*),1,0)) AS [1-3 Ton], 
FROM 
all_trucks_table
WHERE 
(((all_trucks_table.[Form #])=True) AND ((all_trucks_table.Date_of_Change) Between [Forms]![OmsStatus]![StartDateTxt] And [Forms]![OmsStatus]![EndDateTxt]));

 

[VRoscioli]

Try replacing Process=1/* with [Process] Like "1/*"


-V

 

[netrusher]

Thanks Vroscioli,

Works great! You are helping me a lot today!