Reports and criteria

K

kmhnhsuk

I have a report based on a query that has criteria for one of the fields -
category.

I want the report header to display the category from the criteria. I can
get the first one but if more than one crieria is used - I cannot get a list
of all categories.

i.e. say I select categories - Telephone, Bank, Purchases in the query. In
the report I can only get it to display Telephone and not the others. I am
using a Textbox to display this - perhaps I need something else......

Can anyone help?
 
T

Tarlac

You have to create text box for every category. So if you have 3 categories,
create 3 textboxes and define the control source for each using the
categories you used in the query.
 
K

kmhnhsuk

Thanks for this, though it was not what I was after.

I have a query called qryActivityReport

The query has 6 fields - Date, Reference, Category, Narrative, Debit, Credit

The field Category has criteria specified - this can change each time the
query is run.

I have a report called ActivityReport, based on the query qryActivityReport

In the header of the report I have the title - 'Activity Report for Activity
in the following categories:' I then have a textbox looking at the Category
field of qryActivityReport.

This works fine when there is only one element of criteria specified in the
category field of qryActivityReport, but when there is more than one, the
report only picks up the first criteria.

i.e. If I want to report on activity for category: Telephone, then the
report is okay, however if I want to report on activity for Telephone and
Bank, then only the word Telephone is picked up on the Report header.

I want a method of capturing the criteria of a field in a query to list on a
report if that make sense to anyone!
 
Top