Hi John,
I have a report "Members CST Payment Summary" with Record Source: "Members CST Payment Summary Report Query"
SELECT CstPayment.MemberID, CstPayment.SurName, CstPayment.GivenName, CstPayment.GenderStatus, CstPayment.CstName, CstPayment.TransactionDate, CstPayment.Details, CstPayment.AirTicket, CstPayment.TourBasicAmount, CstPayment.NameOfCurrencyTour, CstPayment.TourCost, CstPayment.MiscCostDetail, CstPayment.MiscBasicAmount, CstPayment.NameOfCurrencyMisc, CstPayment.MiscCost, CstPayment.AmountPayable, CstPayment.AmountDeposited
FROM CstPayment
WHERE (((CstPayment.CstName)=[Forms]![Members CST Payment Summary Dialog]![cmbCstName]))
ORDER BY CstPayment.MemberID;
On reports MemberID Header some records are showing complete data OR fields, but some are not displaying fields:
AirTicket, TourBasicAmount, NameOfCurrencyTour, TourCost, MiscCostDetail, MiscBasicAmount, NameOfCurrencyMisc, MiscCost
I am displaying fields Details, TransactionDate, AmountDeposited on reports Detail section.
John in need to resolve it most urgently as my boss is in a meeting and needs this report.
I hope i would get prompt help now.
Best regards,
Khalid
__._,_.___
Posted by: Khalid Tanweer <khalidtanweerburrah@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Yahoo Groups
Improved Group Homepage!
The About page of your Group now gives you a heads up display of recent activity, including the latest photos and files
Yahoo Groups
Control your view and sort preferences per Yahoo Group
You can now control your default Sort & View Preferences for Conversations, Photos and Files in the membership settings page.
.
__,_._,___
Tidak ada komentar:
Posting Komentar