Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 153
  • Last Modified:

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 .
0
Inga_dusha
Asked:
Inga_dusha
  • 3
  • 3
1 Solution
 
Anthony PerkinsCommented:
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
0
 
Inga_dushaAuthor Commented:
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

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

Anthony

0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Inga_dushaAuthor Commented:
Access ,

can you help me ,because I don't know how to do this .
Thanks.
0
 
Anthony PerkinsCommented:
Change your Select statement to (untested):
SELECT *, IIF(Grade>85, 'Very Good', 'Very Bad') As GradeText From Grades

Than add the GradeText to your report like you would any other column.

Anthony
0
 
Inga_dushaAuthor Commented:
Thanks a lot !!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now