Khalid-
You can run the query outside the report. The query will prompt you for the parameter value. Simply enter the CstName that you want to test.
For the one that is failing, what do you see in the table for that CstName value?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jul 19, 2014, at 9:51 AM, Khalid Tanweer khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
Control source must be correct for the fields as on certain rows i am getting the data. Further i cannot run the query directly as field "CstName" has the criteria "[Forms]![Members CST Payment Summary Dialog]![cmbCstName]"
One thing more i have opened the same report selecting another "CstName" and it is giving no problems.
I will be away for some time, as it is time for opening fasting here.
See you,
Khalid
On Saturday, July 19, 2014 6:34 PM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Khalid-
Is the Control Source correct for the fields that aren't displaying data? Do you have any code in the report?
If the controls are bound directly to the fields in the query, there should be no problem. Have you tried just running the query that is the Record Source?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jul 19, 2014, at 9:14 AM, Khalid Tanweer khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
Nothing such like you are saying, for numeric controls i can see 0 (Zero), and i can see NameOfCurrencyTour, NameOfCurrencyMisc. (which is "EUR")
On some rows "MiscCostDetail" is displaying and on some not.
Khalid
On Saturday, July 19, 2014 5:54 PM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Khalid-
Do you see anything in the controls? If you see something like ####, that means the control isn't big enough to display the data.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jul 19, 2014, at 8:48 AM, Khalid Tanweer khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
CstPayment is a table and and Yes i can see values in the columns "missing" data in report.
Regards,
Khalid
On Saturday, July 19, 2014 5:33 PM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Khalid-
Is CstPayment a query or a table? If you open CstPayment as a Datasheet, do you see values in the columns that are "missing" data? The report can't display data that doesn't exist.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Outy
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jul 19, 2014, at 8:15 AM, Khalid Tanweer khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
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: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
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