I have table that has contract info
it looks like this
contractnum date travel webcosts e-mailcosts
123 01/01/03 $5 $6 $7
123 02/01/03 $10 $16 $17
is there anyway to make a crosstab query(or something that acts like a crosstab query) such that it will sum up the travel field, webcosts and emailcosts so i can make one report
anyhelp would be appreciated thanks
mball
it looks like this
contractnum date travel webcosts e-mailcosts
123 01/01/03 $5 $6 $7
123 02/01/03 $10 $16 $17
is there anyway to make a crosstab query(or something that acts like a crosstab query) such that it will sum up the travel field, webcosts and emailcosts so i can make one report
anyhelp would be appreciated thanks
mball