Help with Customized Reports!!

  • Thread starter Thread starter Sokki Hong
  • Start date Start date
S

Sokki Hong

First of all, I want the report to be divided into three
sections. One section listing out all of the data that
has priority 1. One section listing all data that has
priority 2. one section listing all data that has
priority 3.

Secondly, in each section there is a Field
called 'Status'(Subform imbedded in the master form). In
this field multiple data, however I would only want it to
show the latest data in the report. Please let me know if
any one knows how to do either one or the other, or both.
Thank you.
 
If you can write a Calculated field to get the "3
Priorities," you can Group on that Calculated field in
your Report design.

The "latest data," if based on a Date, can use a
Calculated field (Aggregate Query) using "Max".

HTH - Bob
 
Sokki said:
First of all, I want the report to be divided into three
sections. One section listing out all of the data that
has priority 1. One section listing all data that has
priority 2. one section listing all data that has
priority 3.
Click to expand...

Use Sorting and Grouping (View menu) on the Priority field.
You will probably want to have at least a group header for
the priority level related data and posiibly a group footer
to display the Count of items in each group.

Secondly, in each section there is a Field
called 'Status'(Subform imbedded in the master form). In
this field multiple data, however I would only want it to
show the latest data in the report.
Click to expand...

This should be done in the report's record source query
using a subquery. it should be something like:

SELECT T.*
FROM thetable AS T
WHERE T.StatusDate = (SELECT Max(X.StatusDate)
FROM thetable AS X
WHERE T.projectID = X.projectID)

If that too vague, it because you didn't post enough
information about the table and it's data fields for me to
be any more specific.
 
Back
Top