Re: Difference between Crosstab Query and Table Filters?
- From: "Michel Walsh" <vanderghast@VirusAreFunnierThanSpam>
- Date: Mon, 25 Jul 2005 14:54:46 -0400
Hi,
A crosstab query generates NEW FIELDS from actual data: the new fields,
horizontally, come from data values (whatever expression you typed after the
word PIVOT in the crosstab query). Since a crosstab also re_group the
fields, the crosstab has generally less record than the initial table, as
does a standard Total query.
A filter use only existing fields, does not create new field. As example, it
would pick only the records that have the value "Seattle" under the field
City.
If the PIVOT is the field City, as example, for the crosstab, then you will
have a new field called Seattle, as example, another one called Paris, and
so on.
A filter would not change the structure of the table, at all, while a
crosstab creates a lot of new fields, eventually.
Hoping it may help,
Vanderghast, Access MVP
"Don S" <nomailhere@xxxxxxxxxx> wrote in message
news:mi1ae15fjqlmh58vn60ltcd20a0da3j3vp@xxxxxxxxxx
>I have a crosstab query that selects data based on the contents of 5
> fields. They aren't complex - simply state code (2 digits), territory
> (0 or 1) etc.
>
> When I run the crosstab query, I get different results than when I use
> filter by selection with the identical selection criteria.
>
> What am I missing? What resource should I study to become more
> familar with the difference between these two approaches?
>
> I am using Access 2003 but the database is in Access 2000 format (I
> didn't convert it).
>
> Thanks!
> Don S
.
- Follow-Ups:
- References:
- Prev by Date: Re: Update Query to delete some fields information
- Next by Date: Re: Union Query not working yet
- Previous by thread: Difference between Crosstab Query and Table Filters?
- Next by thread: Re: Difference between Crosstab Query and Table Filters?
- Index(es):
Relevant Pages
|
