how to build the quires in Access Db by specific requirement

Abdalla Elawad

hi guys

please help me

i need to build query by select to certain columns and sum of a certain columns from specific tbl in MS-ACCESS . I attached the Table (Data).

i need to select the following columns :

Country , year , cc_code , commdity_code , value(Sum) ,weight (Sum), QY (Sum)

According to Country Name and year and cc_code like(09) and commdity_code (serach by prefix 3 no. not all number like 04480233 just like (044 only)

This is Table :

Excute Query :

Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abdalla Elawad8y ago
I deal with One Table , this is problem

i have query like below but contains to more parameter but in need to pass only (COUNTRY) and full dtails to each year .

this is query :

SELECT Data.COUNTRY_DESC_AR, Data.TRD_YR, Data.CC_CODE, Sum(Data.VALUE) AS SumOfVALUE, Sum(Data.QTY) AS SumOfQTY
FROM Data
WHERE (((Data.COMMODTIY_CODE) Like [Enter Commdity Code:]))
GROUP BY Data.COUNTRY_DESC_AR, Data.TRD_YR, Data.CC_CODE
HAVING (((Data.COUNTRY_DESC_AR)=[Enter Country Name:]) AND ((Data.TRD_YR)=[Enter Year:]) AND ((Data.CC_CODE)=[Enter CC Code:]));
Abdalla Elawad8y ago
Hi Thakur
Letus thank you , already upload the table as image , i need to Select from this table Year,Country ,Commdity_Code ,CC_Code,Value , Quantity , Weight

Thank you
Dharmraj Thakur8y ago
Please show table and relationship structure from where you want the data