Creating Quarterly totals

[watson925]

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

 

[Beetle]

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.

 

[watson925]

Thank you - that works when I use a select query but not a cross tab - not
sure why?
--
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

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

 

[Beetle]

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

Thank you - that works when I use a select query but not a cross tab - not
sure why?
--
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

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

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

Thank you - that works when I use a select query but not a cross tab - not
sure why?
--
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


:

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

 

[RR1976]

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

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

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

Thank you - that works when I use a select query but not a cross tab - not
sure why?
--
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


:

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