I have a databse in Access and I have a form that has a combo box. I need to access the value that user selects from combo box and use it in a query like:
SELECT t2.[Que$tor version name], qv.Date, ([t2].[version]/[t1]. [version7]*100) AS ICX_Value FROM [SELECT q.[Que$tor version name], sum(q.[cost]) as [version7] FROM [Project info Tbl] as p INNER JOIN [QUESTOR Run tbl] as q ON p.[Project ID] = q.[Project ID] where p.[Forms]![FormCombo]![Combo0]! [List]![ListIndex]=yes and (q.[Que$tor version name]="7.3") group by q.[Que$tor version name]]. AS t1, [SELECT q.[Que$tor version name], sum(q.[cost]) as [version] FROM [Project info Tbl] as p INNER JOIN [QUESTOR Run tbl] as q ON p.[Project ID] = q.[Project ID] where p.[Forms]![FormCombo]![Combo0] =yes group by q.[Que$tor version name]]. AS t2 INNER JOIN [QUESTOR Version Information tbl] AS qv ON t2.[Que$tor version name] = qv. [QUE$TOR Version Name]; It still comes with an Enter Parameter Value box. I need some help with this. Thank you Beulah
