Query for same Sales Receipt No with diff Payment Mode

P

PaldenTsokyi

How do I set parameter query for the same Sales Receipt No with different
payment mode to display?

The table fields are as follows:-
ReceiptNo Date PMode ItemNo Transact
AA00001 01/03/06 Cash ZP C
AA00002 01/03/06 Cash ZP C
AA00002 01/03/06 Visa ZP C
AA00003 01/03/06 MasterCard ZP C

From the above list I only want the ReceiptNo AA00002 to be display and my
Query design views are as follows:-

Select Mtdsale1.ReceiptNo, Mtdsale1.Date, Mtdsale1.Transact,
Sum(Mtdsale2.Quantity) As SumOfQuantity, Mtdsale2.ItemNo, Mtdsale2.PMode
From Mtdsale1 Inner Join Mtdsale2 on Mtdsale1.ReceiptNo = Mtdsale2.ReceiptNo
Group By Mtdsale1.ReceiptNo, Mtdsale1.Date, Mtdsale1.Transact,
Mtdsale2.ItemNo, Mtdsale2.PMode
Having (((Mtdsale1.Date)=[Enter Date]) And ((Mtdsale1.Transact)<>"X") And
((Mtdsale2.ItemNo)="ZP"));

Greatly apreciated if anyone can help.......Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top