i never made a report so complicated before so all of your assistance would be great.

i have a date field that is based on one day. i want to pull the date field and have it to total by month. also, i need to be able to pull this report by range.

am i going to have to create mulitple queries for this? my main goal is to achieve this as easy as possible.

thank you all as always.



[This message has been edited by gino (edited 08-25-2000).]

New query with the fields you require, Add date by month group by, dateserial group by sort however, range group by, other fields sum or whatever you want. Report wizard will create report which you can then tidy as you wish.

thanks, i never used the wizards before but i guess its time for me to use them.