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!
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!