I have generated a crosstab query to show invoices by customer by month for
2008. I would like to total the invoices for the last three months. I have
a field in my table the is Month Number and would like the flexibility to
change the query to select any 3 months I am looking for. I have tried dsum
but not working.

I would appreciate any help. thanks
--
watson925

One option.

In your crosstab query, in the criteria row for MonthNo put;

Between [Enter Beginning Month] And [Enter Ending Month]

You would then be prompted for the values each time the xtab query is
executed.
--
_________

Sean Bailey


"watson925" wrote:

> I have generated a crosstab query to show invoices by customer by month for
> 2008. I would like to total the invoices for the last three months. I have
> a field in my table the is Month Number and would like the flexibility to
> change the query to select any 3 months I am looking for. I have tried dsum
> but not working.
>
> I would appreciate any help. thanks
> --
> watson925

Thank you - that works when I use a select query but not a cross tab - not
sure why?
--
watson925


"Beetle" wrote:

> One option.
>
> In your crosstab query, in the criteria row for MonthNo put;
>
> Between [Enter Beginning Month] And [Enter Ending Month]
>
> You would then be prompted for the values each time the xtab query is
> executed.
> --
> _________
>
> Sean Bailey
>
>
> "watson925" wrote:
>
> > I have generated a crosstab query to show invoices by customer by month for
> > 2008. I would like to total the invoices for the last three months. I have
> > a field in my table the is Month Number and would like the flexibility to
> > change the query to select any 3 months I am looking for. I have tried dsum
> > but not working.
> >
> > I would appreciate any help. thanks
> > --
> > watson925

Hmmmmm....

What do you mean when you say it doesn't work?

In one of my applications I have a crosstab query that is similar to the
one you described. It has Month number as the Column Heading. When
I put that in the criteria row and enter 1 and 3 at the prompts it returns
only the first three months.
--
_________

Sean Bailey


"watson925" wrote:

> Thank you - that works when I use a select query but not a cross tab - not
> sure why?
> --
> watson925
>
>
> "Beetle" wrote:
>
> > One option.
> >
> > In your crosstab query, in the criteria row for MonthNo put;
> >
> > Between [Enter Beginning Month] And [Enter Ending Month]
> >
> > You would then be prompted for the values each time the xtab query is
> > executed.
> > --
> > _________
> >
> > Sean Bailey
> >
> >
> > "watson925" wrote:
> >
> > > I have generated a crosstab query to show invoices by customer by month for
> > > 2008. I would like to total the invoices for the last three months. I have
> > > a field in my table the is Month Number and would like the flexibility to
> > > change the query to select any 3 months I am looking for. I have tried dsum
> > > but not working.
> > >
> > > I would appreciate any help. thanks
> > > --
> > > watson925

It says it does not recognize [Enter Beginning Month] as a valid field name
or expression. When I ran it as a select query, it does not add the months
together but shows them separately. I want them added together - a sum of
all three months.

Hope that makes sense - thanks for your continued feedback.
--
watson925


"Beetle" wrote:

> Hmmmmm....
>
> What do you mean when you say it doesn't work?
>
> In one of my applications I have a crosstab query that is similar to the
> one you described. It has Month number as the Column Heading. When
> I put that in the criteria row and enter 1 and 3 at the prompts it returns
> only the first three months.
> --
> _________
>
> Sean Bailey
>
>
> "watson925" wrote:
>
> > Thank you - that works when I use a select query but not a cross tab - not
> > sure why?
> > --
> > watson925
> >
> >
> > "Beetle" wrote:
> >
> > > One option.
> > >
> > > In your crosstab query, in the criteria row for MonthNo put;
> > >
> > > Between [Enter Beginning Month] And [Enter Ending Month]
> > >
> > > You would then be prompted for the values each time the xtab query is
> > > executed.
> > > --
> > > _________
> > >
> > > Sean Bailey
> > >
> > >
> > > "watson925" wrote:
> > >
> > > > I have generated a crosstab query to show invoices by customer by month for
> > > > 2008. I would like to total the invoices for the last three months. I have
> > > > a field in my table the is Month Number and would like the flexibility to
> > > > change the query to select any 3 months I am looking for. I have tried dsum
> > > > but not working.
> > > >
> > > > I would appreciate any help. thanks
> > > > --
> > > > watson925

I'm pretty sure in a crosstab query you will need to set [enter beginning
month] and [enter ending month]as query parameters. If you right-click in
the query and then select parameters you will pull up a small screen that
sets these parameters. It should look something like this:

Parameter Data Type

[enter beginning month] Date/Time
[enter ending month] Date/Time

This might work
--
Ray Rivera


"watson925" wrote:

> It says it does not recognize [Enter Beginning Month] as a valid field name
> or expression. When I ran it as a select query, it does not add the months
> together but shows them separately. I want them added together - a sum of
> all three months.
>
> Hope that makes sense - thanks for your continued feedback.
> --
> watson925
>
>
> "Beetle" wrote:
>
> > Hmmmmm....
> >
> > What do you mean when you say it doesn't work?
> >
> > In one of my applications I have a crosstab query that is similar to the
> > one you described. It has Month number as the Column Heading. When
> > I put that in the criteria row and enter 1 and 3 at the prompts it returns
> > only the first three months.
> > --
> > _________
> >
> > Sean Bailey
> >
> >
> > "watson925" wrote:
> >
> > > Thank you - that works when I use a select query but not a cross tab - not
> > > sure why?
> > > --
> > > watson925
> > >
> > >
> > > "Beetle" wrote:
> > >
> > > > One option.
> > > >
> > > > In your crosstab query, in the criteria row for MonthNo put;
> > > >
> > > > Between [Enter Beginning Month] And [Enter Ending Month]
> > > >
> > > > You would then be prompted for the values each time the xtab query is
> > > > executed.
> > > > --
> > > > _________
> > > >
> > > > Sean Bailey
> > > >
> > > >
> > > > "watson925" wrote:
> > > >
> > > > > I have generated a crosstab query to show invoices by customer by month for
> > > > > 2008. I would like to total the invoices for the last three months. I have
> > > > > a field in my table the is Month Number and would like the flexibility to
> > > > > change the query to select any 3 months I am looking for. I have tried dsum
> > > > > but not working.
> > > > >
> > > > > I would appreciate any help. thanks
> > > > > --
> > > > > watson925