Your chart display depends on the Row Source property and the Link
Master/Child. I expect your Link properties will be the Sektor.
If you can't figure this out, reply back with the Row Source and link
properties.
--
Duane Hookom
Microsoft Access MVP
"Ticotion" wrote:
> Hi Duana
>
> So I solve the issue regarding the empty Sektor field. Now I got it to draw
> some sort of a chart but it kind off cumulates all the values in one bar. It
> should show
> [Fejl Hyp] (Frequence) on the y-axe as bars and the [Fejlårsag] (Error
> Cause) on the x-axe and [Hyp procent] (Frequence in pct) on the y2-axe. The
> chart should be set-up to do this as I've copied the data from the query into
> the datasheet. So in desing mode I get the right layout.
>
> I link with sector but I think this is the problem. I've tried linking with
> [Fejlårsag] but here I get an empty result once again.
>
> Any suggestions?
>
> Br
> Ticotion
>
>
>
> "Duane Hookom" wrote:
>
> > I was wondering why you apply a WHERE CONDITION in the DoCmd.OpenReport as
> > well as having a similar WHERE CLAUSE in the record source query. You
> > shouldn't need both.
> >
> > If the text box is blank the chart will be blank.
> > --
> > Duane Hookom
> > Microsoft Access MVP
> >
> >
> > "Ticotion" wrote:
> >
> > > Hi Duane
> > >
> > > The chart is placed in the report header and yes I have a text box where the
> > > control source is Sektor. But I have now noticed that it seems like this
> > > textbox does not have anything in it. I've tried changing the control source
> > > to the combobox input from the form. This gives an error. There should be a
> > > sektor number. So maybe it is because the filter is not be set correctly?
> > >
> > > Br
> > > Ticotion
> > >
> > > "Duane Hookom" wrote:
> > >
> > > > Is the chart in the Sektor group header or footer?
> > > > Do you have a text box bound to Sektor in the same report section as the
> > > > chart?
> > > >
> > > > --
> > > > Duane Hookom
> > > > Microsoft Access MVP
> > > >
> > > >
> > > > "Ticotion" wrote:
> > > >
> > > > > Hi
> > > > >
> > > > > I have once again problems using access 2003 chart possibilities.
> > > > >
> > > > > I have a form that filters a report using the following code:
> > > > >
> > > > > DoCmd.OpenReport "Rpt_SIMparetoH", acPreview, , "[Sektor] =" &
> > > > > Me.Kombinationsboks16 & " and [Dato] = #" & Format(Me.Kombinationsboks7,
> > > > > "mm\/dd\/yyyy") & "#", , acWindowNormal
> > > > >
> > > > > I then have a report that builds on the following query
> > > > >
> > > > > SELECT qrySimSektorparetoh.Dato, qrySimSektorparetoh.Sektor,
> > > > > qrySimSektorparetoh.Fejlårsag, qrySimSektorparetoh.[Fejlen hyppighed],
> > > > > qrySimSektorparetoh.[Hyp total], qrySimSektorparetoh.[Hyp procent]
> > > > > FROM qrySimSektorparetoh
> > > > > WHERE
> > > > > (((qrySimSektorparetoh.Dato)=[Forms]![frmSIMpareto]![Kombinationsboks7]) AND
> > > > > ((qrySimSektorparetoh.Sektor)=[Forms]![frmSIMpareto]![Kombinationsboks16]));
> > > > >
> > > > >
> > > > > in the report I've placed a chart that have the following source code
> > > > >
> > > > > SELECT qrySIMParetoHyppighed.Dato, qrySIMParetoHyppighed.Sektor,
> > > > > qrySIMParetoHyppighed.Fejlårsag, Sum(qrySIMParetoHyppighed.[Fejlen
> > > > > hyppighed]) AS [Fejl Hyp], Sum(qrySIMParetoHyppighed.[Hyp procent]) AS [Hyp
> > > > > pct]
> > > > > FROM qrySIMParetoHyppighed
> > > > > GROUP BY qrySIMParetoHyppighed.Dato, qrySIMParetoHyppighed.Sektor,
> > > > > qrySIMParetoHyppighed.Fejlårsag
> > > > > HAVING
> > > > > (((qrySIMParetoHyppighed.Dato)=[Forms]![frmSIMpareto]![Kombinationsboks7])
> > > > > AND
> > > > > ((qrySIMParetoHyppighed.Sektor)=[Forms]![frmSIMpareto]![Kombinationsboks16]))
> > > > > ORDER BY Sum(qrySIMParetoHyppighed.[Fejlen hyppighed]) DESC;
> > > > >
> > > > >
> > > > > I've linked the two using Sektor both as master and as child. The problem is
> > > > > that I recieve an empty chart. Can anyone help?
> > > > >
> > > > > Once again thank you for all your help
> > > > >
> > > > > Ticotion
> > > > >
|
Similar Threads
