Create a report by field values

[Dante1980]

Hi There,

I have a problem........and I hope you can help me out!!

I created an overall report that prints out all different information coming from a Table (Tasks), like: "Milestones", "Tasks", "Open Date", "Category", etc..
The field "Category" has different values changing between 6 differents possibilites (Implementation, Data Analysis, etc).

I'd like to create a report for each of those 6 possible values keeping the same format of the overall report...

Does it exsist any filter that I can apply in the properties window of the field "Category" in the design view of the report?

Thanks a lot

 

[hamzaba]

I think u can do as if u create a query from the table "Tasks" displaying all fields required in your report by the name "qTasks". Then in the Design Query view, just type "like [What Category] &*" in the criteria row of the Category field. Set this query as Record Source of your Report. Thats all.

While running your report, u will be prompted to enter Category of your desire, if not given, all categories will appear in ur report. Hope it works.