HELP!!!!! to retrive data related to a composite primary key

[coroll]

Hi,
i want to retrive data from a table which has a composite primary key. This is the query
im using;
"select price from Item_size where primarykey='"+pk+"'"

But it does not work. Im using MS Access. can anyone help me!

[KidRocker]

select dept.DVID as dept_division
, dept.DPID as dept_id
, sect.SCID as section_id
, sect.SCNAME as section_name
, count(EMPNO) as staff_count
from DEPARTMENT

http://searchoracle.techtarget.com/answer/Retrieve-data-related-by-composite-key

[Ancient Dragon]

A composite key means the key consists of two or more fields.
"select price from item_size where field1 = "something" and field2 = "smethin else" and ..."