I need to make a report that will list my client's monthly revenue and
the year to date. I want it to basically look like this
Jan Feb
March etc. YTD Client1 $XXXX.XX %
$XXXX.XX % $XXXX.XX % $XXXX.XX % $XXXX.XX %
I have all of the data entered in as billing periods which there are
two per month, and it is usually the 1st and 15th of every month. I
am not sure how to get it to pull the data for each month seperately.
Do I need separate queries for each one?
Thanks for any help!!!!
the year to date. I want it to basically look like this
Jan Feb
March etc. YTD Client1 $XXXX.XX %
$XXXX.XX % $XXXX.XX % $XXXX.XX % $XXXX.XX %
I have all of the data entered in as billing periods which there are
two per month, and it is usually the 1st and 15th of every month. I
am not sure how to get it to pull the data for each month seperately.
Do I need separate queries for each one?
Thanks for any help!!!!