I want to group records in the report based on three fields but I don't want the records to be nested into three levels. Instead I want a grouping on three fields with one level.

For example I want to bundle Shiping Date, Receiving Date and Purchasing Date.

Hence for the Date December 31, 2004.....

I want any record that either has a Shipping Date, or Receiving date or Purchasing Date to be included in this section without any nesting.

The same record that appeared in the December 31, 2004 section can appear in January 1, 2005 section because perhaps its shipping date falls on that day.

So any record can appear in a maximum of 3 sections (If all three dates are different)and a minimum of 1 (If all three dates are the same).

The only level of grouping is date but it is based on three fields.

Is this possible?

Thanks.

Reports are good at establishing grouping levels and queries are good at organizing your data. I would suggest that you look at queries first as a way of defining your data and then base a report on that query.

Similar reply - if you have all the dates in a table, and left join them to the 3x the table one on each date field, then it would/should return three records, and only be grouped on the date.

This does mean that you need to add new dates etc to the table :)


Vince

Thanks for the response ... with your suggestions I figured it out.

Thanks