asked on

Detail section in Data reports

How can I add for each record (that shown in detail section) some text .

For example :
-----------Header Section----------------
Num Subject Grade
rec
-----------Detail Section----------------
1 History 90 TEXT<--
2 English 60 TEXT<--
3 Mathematics 80 TEXT<--

If grade>85 I want to write near it "Very Goog"
(in the TEXT label)
elseif
I want to write near it "Very Bad"
(in the TEXT label)
endif]

How can I do this ?Please help me .

Anthony Perkins

You will need to add this text to your Recordset. Post your SQL statement and I can amend as needed to add the needed columns.

Anthony

Inga_dusha

ASKER

Its' mean that I need to add column to the table itself?
And if I don't want to make changes to the table?

For example sSQl= "SELECT * From Grades"

Table Grades:
ID
Subject
Grade

Anthony Perkins

Not to the table, but to the recordset. What you need is a calculated column. Is this Access or SQL Server?

Anthony

Inga_dusha

ASKER

Access ,

can you help me ,because I don't know how to do this .
Thanks.

ASKER CERTIFIED SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Inga_dusha

ASKER

Thanks a lot !!!