Hi All,
I have some reports which i am opening through Dialog Form, which are working right.
But now i am stucked for many reports for which report is not opening and Dialog Form to fill parameters comes to a blank form, further i am unable to close this form unless i right click on the form and click on "Form Design".
I have further noticed that any query which have 'Sum' or 'Count' they are not working.
For example i put down the query:
SELECT ClientsClaimPerPiece.ClientCIN, ClientsClaimPerPiece.ClientName, ClientsClaimPerPiece.ConsignmentNo, ClientsClaimPerPiece.CartonNo, ClientsClaimPerPiece.Product, ClientsClaimPerPiece.ProductQtyClaimed, ClientsClaimPerPiece.PricePerPc, ClientsClaimPerPiece.ClaimPerPc, Sum(ClientsClaimPerPiece.ProductQtyClaimed) AS TotQtyClaimed
FROM ClientsClaimPerPiece
GROUP BY ClientsClaimPerPiece.ClientCIN, ClientsClaimPerPiece.ClientName, ClientsClaimPerPiece.ConsignmentNo, ClientsClaimPerPiece.CartonNo, ClientsClaimPerPiece.Product, ClientsClaimPerPiece.ProductQtyClaimed, ClientsClaimPerPiece.PricePerPc, ClientsClaimPerPiece.ClaimPerPc
HAVING (((ClientsClaimPerPiece.ClientCIN)=[Forms]![Clients Claim Undelivered Cargo Per Pc Dialog]![ClientCIN]) AND ((ClientsClaimPerPiece.ClientName) Is Not Null) AND ((ClientsClaimPerPiece.ConsignmentNo)=[Forms]![Clients Claim Undelivered Cargo Per Pc Dialog]![ConsignmentNo]) AND ((ClientsClaimPerPiece.CartonNo) Is Not Null) AND ((ClientsClaimPerPiece.Product) Is Not Null) AND ((ClientsClaimPerPiece.ProductQtyClaimed) Is Not Null) AND ((ClientsClaimPerPiece.PricePerPc) Is Not Null) AND ((ClientsClaimPerPiece.ClaimPerPc) Is Not Null))
ORDER BY ClientsClaimPerPiece.CartonNo, ClientsClaimPerPiece.Product;
============
Could somebody help. Is there some other method to open Dialog Forms for such queries OR something is wrong in this query.
============
The report works perfectly if i do not use Dialog Form and simply in the query i put criteria
Like [Enter Client CIN]
Like [Enter Consignment No]
Thanks in advance for assistance.
Khalid
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar