Hi Rebeca,
There is also a guide to doing it in this link,
http://office.microsoft.com/en-us/access-help/designing-your-first-pivottable-pivotchart-views-in-access-HA001034580.aspx
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Rebecca
>
> Filtering a query's results will not apply that filter to the query itself. You need to do that in the query's criteria lines. Open the query in design view and add the filtering you want. Say you want all orders with a client name of Heyal Buyanything.
>
> On the criteria line for the field Client name put that name surrounded in quotes.
>
> Sorry for the slow reply. YOur post must have been overlooked.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, Rebeca Muller <becaml@> wrote:
> >
> > Hello all,
> >
> > I have built a query using the pivot table format.
> > Having filtered some data and saving it, when I create a report based in this
> > query or copy it to a blank report, the result is totally different. Some data
> > should be hiden since the filter does not capture it. In spite of that, all
> > data is shown.
> >
> > The solution seems to be simple, but I could not find
> > it. Does someone have a tip for me?
> >
> > Thank you very much !
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
Rabu, 09 Mei 2012
[MS_AccessPros] Re: Doubt about query using the pivot table format
__._,_.___
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar