RE: CrossTab Challenge

I can't really do it that way because I have three values not one and a
crosstab only allows for one. So I have project as a row heading, resource as
a row heading and then the week or week number as you indicated as the column
heading but I need to have three values the forecast the actual and the
variance.

Hope that made sense.
--
Michal Joyce
Project Management IS Analyst
Aflac - Project Management Office


"Jeff C" wrote:

Try backing up and looking at your queries before you create your crosstab.

Your date can be the formatted date field format([datefield],"ww") which
will always translate into your column heading

Your Resource is yoru row heading and the hours are your value so, create a
union query of your two or three or four queries that have all your data and
then, place your union query in the query builder and build your crosstab out
of that.
--
Jeff C
Live Well .. Be Happy In All You Do


"MJatAflac" wrote:

I have an interesting challenge with a couple of CrossTab Queries.

I have a crosstab that gives Project Resource and then Forecasted Hours by
week.
I have a crosstab that gives Project Resource and the Actual Hours by week.

I need a query that combines the two so that I end up with the following:

Project Resource Week1 Forecast Week1 Actual Week 1 Variance Week2 Forecast
etc...

The problem is that the user wants to be able to select the date range for
the report so I'll never know what the dates will be. I can restrict them to
a six week range and I know the dates will always be in the past. But other
than that It's anyone's guess.

I'm thinking that somehow I need to translate the week into 1, 2, 3, 4, 5,
and 6 but I have no clue how to do this.

Any ideas?

Thanks,

m
--
Michal Joyce
Project Management IS Analyst
Aflac - Project Management Office
.

Relevant Pages

  • RE: CrossTab Challenge
    ... OK now, follow me, in all three queries you have a row heading whose value ... in all three queries you can build your union query. ... Aflac - Project Management Office ...
    (microsoft.public.access.queries)
  • Re: Cross Tab Queries
    ... Crosstab: Row Heading Row Heading ... Crosstab: Column Heading ... above query: ...
    (microsoft.public.access.queries)
  • Re: Crosstab Situation
    ... Crosstab queries, ... My only question at this point would be on how to use a Union query for the ... "Duane Hookom" wrote: ... >>> MS Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Cross Tabulation Query / Report
    ... I think a crosstab might work if you add the field to the Row Heading ... While this is expected in many SQL NGs, ... based on a PG Query. ...
    (microsoft.public.access.reports)
  • Re: Cross Tabulation Query / Report
    ... I think a crosstab might work if you add the field to the Row Heading ... While this is expected in many SQL NGs, ... based on a PG Query. ...
    (microsoft.public.access.queries)