Hi

I am running a crosstab query using a range of dates as the column heading,
product name as row headings and a summation of purchase earnings as the
value entry for the data. Some 'product name' might have more than one
amount due on the same day because different people are buying the product
(different invoices). The amount earned by product is calculated in another
simple query where the amounts due are derived by an expression of unit *
unitcost.

The problem is that the data will not accumulate the amounts of the 'second'
invoice in the output of values (summation of earnigs for the product on a
particular day in the date range).

what am I doing wrong?????

Thanks for the help
Joe

Joe,

Can it be that for the column that contains the value in designview in
stead of the sum-function contains first,min or max ?
Or do the date-values of your database contain a time-component ?
In the last case you could change the field-expression for the
column-header into invdate:int(invoicedate) to get 1 column for every
date.
If you include the SQL-expression in your message it would be much
easier to give an accurate answer.

Marc

"jbachich" <jbachich (AT) snip (DOT) net> wrote