Query different items which has got their own Invoiceno

Dear Sir

I have a database in Access 2002.

There are fields i.e. item_name,invoiceno

Now, I want to write SQL statement by which I can show specific item_name against its invoiceno.

I have written below statement which does show only specified item_name.

There are other items and their invoiceno

Code:

---

SELECT tblpurchasesupplyqty.item_name, tblpurchasesupplyqty.invoiceno
FROM tblpurchasesupplyqty
WHERE (((tblpurchasesupplyqty.invoiceno)="Mul-200"));

---

Please help, how can I have the correct statement?

Appreciate, if you would come back at your earliest.


Regards
Pervez

If you mean you would like the above Access statement to work in SQL, then here...

Code:

---

SELECT item_name, invoiceno
FROM tblpurchasesupplyqty
WHERE invoiceno = 'Mul-200'

---

If you need any more information let me know.

Please add to my reputation if this helps.

Thanks.