|
 |
access thread: Very Urgent Crosstab query
Message #1 by "George Oro" <george@c...> on Sat, 22 Mar 2003 20:26:46 +0400
|
|
For instance there's no Male or female in Region4, how can I view or keep
Region4 on my query and in report also?
Gender Region1 Region2 Region3 Region4
Male 1 5
Female 5 4 5
Gender & Regions are dropdown tables...
Sorry I'm just very new using Crosstab...
Any help would be highly appreciate...
TIA,
George
Message #2 by "George Oro" <george@c...> on Sat, 22 Mar 2003 20:46:20 +0400
|
|
PS.
Is it possible also to view or keep un-used Rows?
TIA
>
>
> For instance there's no Male or female in Region4, how can I view or keep
> Region4 on my query and in report also?
>
>
> Gender Region1 Region2 Region3 Region4
> Male 1 5
> Female 5 4 5
>
>
> Gender & Regions are dropdown tables...
>
> Sorry I'm just very new using Crosstab...
>
> Any help would be highly appreciate...
>
>
> TIA,
> George
>
>
>
>
>
>
Message #3 by "George Oro" <george@c...> on Sun, 23 Mar 2003 09:55:24 +0400
|
|
It seems I solved it! I defined all the columns I required on the columns heading properties.
Cheers,
George
> -----Original Message-----
> From: George Oro [mailto:george@c...]
> Sent: Saturday, March 22, 2003 8:46 PM
> To: Access
> Subject: [access] RE: Very Urgent Crosstab query
>
>
> PS.
> Is it possible also to view or keep un-used Rows?
>
> TIA
>
> >
> >
> > For instance there's no Male or female in Region4, how can I view or keep
> > Region4 on my query and in report also?
> >
> >
> > Gender Region1 Region2 Region3 Region4
> > Male 1 5
> > Female 5 4 5
> >
> >
> > Gender & Regions are dropdown tables...
> >
> > Sorry I'm just very new using Crosstab...
> >
> > Any help would be highly appreciate...
> >
> >
> > TIA,
> > George
> >
> >
> >
> >
> >
> >
>
>
Message #4 by "Darin Marsh" <netadmin@l...> on Mon, 24 Mar 2003 15:47:27
|
|
This sounds like a join issue to me. Do you have multiple tables/queries
involved? If so are they joined? If so you probably have an "Inner" join
and you need an "Outer Right" or "Outer Left" depending on which
table/query houses the empty fields. To accomplish this, edit the query
of the crosstab and right mouse on the join, then properties. The default
radio button is show only records that are "equal", choose the one that
will give you the desired result. One will give you a 'right' join the
other a 'left'. Hope this helps.
Darin
> For instance there's no Male or female in Region4, how can I view or keep
Region4 on my query and in report also?
Gender Region1 Region2 Region3 Region4
Male 1 5
Female 5 4 5
Gender & Regions are dropdown tables...
Sorry I'm just very new using Crosstab...
Any help would be highly appreciate...
TIA,
George
Message #5 by "George Oro" <george@c...> on Tue, 25 Mar 2003 16:04:15 +0400
|
|
Thanks Daren, actually I droped the crosstab I done it other approach...
Cheers,
George
> -----Original Message-----
> From: Darin Marsh [mailto:netadmin@l...]
> Sent: Monday, March 24, 2003 3:47 PM
> To: Access
> Subject: [access] Re: Very Urgent Crosstab query
>
>
> This sounds like a join issue to me. Do you have multiple tables/queries
> involved? If so are they joined? If so you probably have an "Inner" join
> and you need an "Outer Right" or "Outer Left" depending on which
> table/query houses the empty fields. To accomplish this, edit the query
> of the crosstab and right mouse on the join, then properties. The default
> radio button is show only records that are "equal", choose the one that
> will give you the desired result. One will give you a 'right' join the
> other a 'left'. Hope this helps.
>
> Darin
>
>
>
> > For instance there's no Male or female in Region4, how can I view or keep
> Region4 on my query and in report also?
>
>
> Gender Region1 Region2 Region3 Region4
> Male 1 5
> Female 5 4 5
>
>
> Gender & Regions are dropdown tables...
>
> Sorry I'm just very new using Crosstab...
>
> Any help would be highly appreciate...
>
>
> TIA,
> George
>
>
>
>
>
|
|
|
View Cart
