display data in report

[SylvieB]

I need to write a report that shows the stage of an opportunity. There are 4
stages (DG1, DG2, DG3, DG4); The report I have created has a column for each
stage. The information that needs to show under each column is customer,
order value and award date that are associated with the stage.
On the form, I created a check box for each stage. So when the opportunity
passes from one stage to another, the user just put a check mark on the box
and the info is recorded on a table with the customer name, order value and
award date. That works great.
On the report, how can I display the customer, order value and award date
that will show only under the correct stage?

 

[SylvieB]

Hi Arvin
Thank you very much for your prompt response. You are right. What i wanted
to accomplish when i designed it was to keep a record when the stage changes
with a date. So basically when the user puts a check mark on the phase,
today's date get assigned automatically and is saved on the table for report
purposes. I do agree with what you suggest but in this case how would you
assign a date when the stage changes and record it in a table. Thank you