printing dates for the correct code

[AJANETA]

Can you Help

I have a field that is used to hold a code relating to the status of a project for a particular company.

In the table there is also a date field that is used to hold the date the company achieved a certain status.

I want to print out for a company all the status codes and the date achieved.

This report has to be printed landscape so It will print all the company, status codes and the date status was achieved next to it.

How do I get the correct date to appear next to the correct status field.

hope this makes sense.

Janet Anderson (new user)

 

[Roadkill150]

Hello,
Is the date field in the same table as the status field? There are a couple tests you can do.. insert the date field next to your status field then group on status field.. there may be something that you are missing in the records.
Next, i would try setting your record selection to a certain status ie: {statuscode}= "ux55l" and then run the report to see if the date and status are matching up.
Cheers,
-Bruce Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com