Query different items which has got their own Invoiceno

[pervez]

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

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

[gb1983]

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

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.