|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 6th, 2006, 07:10 AM
posted to microsoft.public.access.reports
|
|||
|
|||
Chart with tow link feilds
Good Day everybody,
I have a small problem regarding chart in report. I need to link a chart to my report with tow fields (Branch_Code and Sex_Code). MS Access allows me to link with only one field. The problem is that when I preview my reports it mix tow different records of data in one chart. How I can fix this problem please??? 
|
|
#2
August 6th, 2006, 04:46 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Chart with tow link feilds
There should be no problem linking with almost any number of fields. You can
simply type in your field names with a semi colon between them. -- Duane Hookom MS Access MVP "Youngpioneer" wrote in message ... Good Day everybody, I have a small problem regarding chart in report. I need to link a chart to my report with tow fields (Branch_Code and Sex_Code). MS Access allows me to link with only one field. The problem is that when I preview my reports it mix tow different records of data in one chart. How I can fix this problem please???
|
|
#3
August 7th, 2006, 07:14 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Chart with tow link feilds
Thanks for your response, but the problem is that when I display reports,
other feilds which I am using to link the chart, will apear in the chart For example, when I link the chart with tow feilds: Branch_Code and Sex_Code. First column in the chart will show sex code and then it will show real data??? How I can let other feilds disapear??? Thanks
|
|
#4
August 7th, 2006, 01:10 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Chart with tow link feilds
I don't believe you need to display the fields. IIRC the fields only need to
be in the source query of the chart. -- Duane Hookom MS Access MVP "Youngpioneer" wrote in message ... Thanks for your response, but the problem is that when I display reports, other feilds which I am using to link the chart, will apear in the chart For example, when I link the chart with tow feilds: Branch_Code and Sex_Code. First column in the chart will show sex code and then it will show real data??? How I can let other feilds disapear??? Thanks
|
|
#5
August 8th, 2006, 06:57 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Chart with tow link feilds
Just try it and you will see how it is working. I do not need to display
felids but it is displayed by no chice from me??? how i can make it disappear??? "Duane Hookom" كتب: I don't believe you need to display the fields. IIRC the fields only need to be in the source query of the chart. -- Duane Hookom MS Access MVP "Youngpioneer" wrote in message ... Thanks for your response, but the problem is that when I display reports, other feilds which I am using to link the chart, will apear in the chart For example, when I link the chart with tow feilds: Branch_Code and Sex_Code. First column in the chart will show sex code and then it will show real data??? How I can let other feilds disapear??? Thanks
|
|
#6
August 8th, 2006, 02:38 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Chart with tow link feilds
I just set up a test pie chart in a report that has two link master/child
fields. Neither or these fields are displayed in the chart. The linking fields are in the charts Row Source query but are not selected. The chart is somewhat like a subreport that links on two fields. The two fields must be in the Record Source of the subreport but you don't need to display them. -- Duane Hookom MS Access MVP "Youngpioneer" wrote in message ... Just try it and you will see how it is working. I do not need to display felids but it is displayed by no chice from me??? how i can make it disappear??? "Duane Hookom" ???: I don't believe you need to display the fields. IIRC the fields only need to be in the source query of the chart. -- Duane Hookom MS Access MVP "Youngpioneer" wrote in message ... Thanks for your response, but the problem is that when I display reports, other feilds which I am using to link the chart, will apear in the chart For example, when I link the chart with tow feilds: Branch_Code and Sex_Code. First column in the chart will show sex code and then it will show real data??? How I can let other feilds disapear??? Thanks
|
|
#7
August 9th, 2006, 09:06 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Chart with tow link feilds
Please just try to do it with column chart and tell me what happen with you
"Duane Hookom" كتب: I just set up a test pie chart in a report that has two link master/child fields. Neither or these fields are displayed in the chart. The linking fields are in the charts Row Source query but are not selected. The chart is somewhat like a subreport that links on two fields. The two fields must be in the Record Source of the subreport but you don't need to display them. -- Duane Hookom MS Access MVP "Youngpioneer" wrote in message ... Just try it and you will see how it is working. I do not need to display felids but it is displayed by no chice from me??? how i can make it disappear??? "Duane Hookom" ???: I don't believe you need to display the fields. IIRC the fields only need to be in the source query of the chart. -- Duane Hookom MS Access MVP "Youngpioneer" wrote in message ... Thanks for your response, but the problem is that when I display reports, other feilds which I am using to link the chart, will apear in the chart For example, when I link the chart with tow feilds: Branch_Code and Sex_Code. First column in the chart will show sex code and then it will show real data??? How I can let other feilds disapear??? Thanks
|
|
#8
August 9th, 2006, 03:15 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Chart with tow link feilds
It doesn't make any difference if the chart is pie or column. I have created
an example for you and posted it at http://www.access.hookom.net/Samples.htm -- Duane Hookom MS Access MVP "Youngpioneer" wrote in message ... Please just try to do it with column chart and tell me what happen with you "Duane Hookom" ???: I just set up a test pie chart in a report that has two link master/child fields. Neither or these fields are displayed in the chart. The linking fields are in the charts Row Source query but are not selected. The chart is somewhat like a subreport that links on two fields. The two fields must be in the Record Source of the subreport but you don't need to display them. -- Duane Hookom MS Access MVP "Youngpioneer" wrote in message ... Just try it and you will see how it is working. I do not need to display felids but it is displayed by no chice from me??? how i can make it disappear??? "Duane Hookom" ???: I don't believe you need to display the fields. IIRC the fields only need to be in the source query of the chart. -- Duane Hookom MS Access MVP "Youngpioneer" wrote in message ... Thanks for your response, but the problem is that when I display reports, other feilds which I am using to link the chart, will apear in the chart For example, when I link the chart with tow feilds: Branch_Code and Sex_Code. First column in the chart will show sex code and then it will show real data??? How I can let other feilds disapear??? Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
