I am using Data Reports throug Data Environment, and using Relational Database in MS Access.. I have prepared the query throuh SQL Builder(in data reports) and the query is running OK , but how can I pass parameter in this query to show the results on the data reports.....

my query is as under:

SELECT BRAND_MSTR.BRAND_NAME, EQUIPMENT_MSTR.MODEL, LOCATION_MSTR.LOCATION, SUM(EQUIPMENT_MSTR.QUANTITY) AS QTY, SUB_CATEGORY_MSTR.EQUIPMENT_SUBCATEGORY FROM BRAND_MSTR, EQUIPMENT_MSTR, LOCATION_MSTR, SUB_CATEGORY_MSTR WHERE BRAND_MSTR.BRAND_ID = EQUIPMENT_MSTR.BRAND_ID AND EQUIPMENT_MSTR.LOCATION_ID = LOCATION_MSTR.LOCATION_ID AND EQUIPMENT_MSTR.SUB_CATEGORY_ID = SUB_CATEGORY_MSTR.sub_category_id GROUP BY BRAND_MSTR.BRAND_NAME, EQUIPMENT_MSTR.MODEL, LOCATION_MSTR.LOCATION, SUB_CATEGORY_MSTR.EQUIPMENT_SUBCATEGORY ORDER BY BRAND_MSTR.BRAND_NAME, EQUIPMENT_MSTR.MODEL

in this query there are different tables joined to each other and fields are being called and this Query Shows all data from tables.

Now I want to give input from Text Box or from Combo Box as paramenter to filter it via this query which must show desired output on the reports. i.e a Specific Equipment Name..etc.

You may answer me here or mail me at ..

Thanks.

Edited 6 Years Ago by __avd: Email snipped.

hai friend,

I need the coding or help from you all. Thanks in advance.

I need to pass the query at the runtime to data report from the forms. andbody help me out to my problems.

My mail id:..

Edited 6 Years Ago by __avd: Email Snipped.

This article has been dead for over six months. Start a new discussion instead.