Rabu, 09 Mei 2012

[MS_AccessPros] Re: Doubt about query using the pivot table format

 

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]
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar