TU_SR_DEANSLIST

Steps:

  1. Click the Reporting Tools link.   Step 1
  2. Click the Query link.   Step 2
  3. Click the Query Manager link.   Step 3
  4. Click the Create New Query link.   Step 4
  5. Enter the desired information into the begins with field. Enter "stdnt".   Step 5
  6. Click the Search button.   Step 6
  7. Click the View All link.   Step 7
  8. Release the mouse button.   Step 8
  9. Click an entry in the Add Record column.   Step 9
  10. Click the option.   Step 10
  11. Click the option.   Step 11
  12. Click the option.   Step 12
  13. Release the mouse button.   Step 13
  14. Click the option.   Step 14
  15. Click the option.   Step 15
  16. Scroll the object with the mouse wheel.   Step 16
  17. Click the option.   Step 17
  18. Click the option.   Step 18
  19. Release the mouse button.   Step 19
  20. Click the Show next row (Alt+.) button.   Step 20
  21. Click the option.   Step 21
  22. Click the Show next row (Alt+.) button.   Step 22
  23. Click the option.   Step 23
  24. Release the mouse button.   Step 24
  25. Click the Records tab.   Step 25
  26. Enter the desired information into the begins with field. Enter "names".   Step 26
  27. Click the Search button.   Step 27
  28. Click an entry in the Join Record column.   Step 28
  29. Click the A = STDNT_CAR_TERM - Student Career Term Table link.   Step 29
  30. Click the Add Criteria button.   Step 30
  31. Click the OK button.   Step 31
  32. Release the mouse button.   Step 32
  33. Click the option.   Step 33
  34. Click the option.   Step 34
  35. Release the mouse button.   Step 35
  36. Click the Records tab.   Step 36
  37. Enter the desired information into the begins with field. Enter "address".   Step 37
  38. Click the Search button.   Step 38
  39. Click an entry in the Join Record column.   Step 39
  40. Click the A = STDNT_CAR_TERM - Student Career Term Table link.   Step 40
  41. Click the Add Criteria button.   Step 41
  42. Click the OK button.   Step 42
  43. Release the mouse button.   Step 43
  44. Click the option.   Step 44
  45. Click the option.   Step 45
  46. Click the option.   Step 46
  47. Click the option.   Step 47
  48. Click the option.   Step 48
  49. Click the Fields tab.   Step 49
  50. Click the Reorder / Sort button.   Step 50
  51. Enter the desired information into the New Order By field. Enter "1".   Step 51
  52. Enter the desired information into the New Order By field. Enter "2".   Step 52
  53. Click the OK button.   Step 53
  54. Click the Add Criteria button.   Step 54
  55. Click the Prompt option.   Step 55
  56. Click the New Prompt link.   Step 56
  57. Click the Heading Type list.   Step 57
  58. Click the Text list item.   Step 58
  59. Enter the desired information into the Heading Text field. Enter "Enter ".   Step 59
  60. Click the Edit Type list.   Step 60
  61. Click the No Table Edit list item.   Step 61
  62. Click the OK button.   Step 62
  63. Click the OK button.   Step 63
  64. Click the Add Criteria button.   Step 64
  65. Enter the desired information into the Constant field. Enter "UGRD".   Step 65
  66. Click the OK button.   Step 66
  67. Click the Add Criteria button.   Step 67
  68. Enter the desired information into the Constant field. Enter "F".   Step 68
  69. Click the OK button.   Step 69
  70. Click the Add Criteria button.   Step 70
  71. Click the Condition Type list.   Step 71
  72. Click the in list list item.   Step 72
  73. Click the Select List Members button.   Step 73
  74. Enter the desired information into the Value field. Enter "BS".   Step 74
  75. Click the Add Value button.   Step 75
  76. Enter the desired information into the Value field. Enter "BA".   Step 76
  77. Click the Add Value button.   Step 77
  78. Enter the desired information into the Value field. Enter "BFA".   Step 78
  79. Click the Add Value button.   Step 79
  80. Enter the desired information into the Value field. Enter "BM".   Step 80
  81. Click the Add Value button.   Step 81
  82. Enter the desired information into the Value field. Enter "BTP".   Step 82
  83. Click the Add Value button.   Step 83
  84. Click the OK button.   Step 84
  85. Click the OK button.   Step 85
  86. Click the Add Criteria button.   Step 86
  87. Click the Condition Type list.   Step 87
  88. Click the greater than list item.   Step 88
  89. Enter the desired information into the Constant field. Enter "11.5".   Step 89
  90. Click the OK button.   Step 90
  91. Click the Add Criteria button.   Step 91
  92. Click the Condition Type list.   Step 92
  93. Click the greater than list item.   Step 93
  94. Enter the desired information into the Constant field. Enter "3.499".   Step 94
  95. Click the OK button.   Step 95
  96. Click the Add Criteria button.   Step 96
  97. Enter the desired information into the Constant field. Enter "0".   Step 97
  98. Click the OK button.   Step 98
  99. Release the mouse button.   Step 99
  100. Click the Criteria tab.   Step 100
  101. Click the Add Criteria button.   Step 101
  102. Click the Select Record and Field button.   Step 102
  103. Click the Show Fields button.   Step 103
  104. Click the B.NAME_TYPE - Type of Name link.   Step 104
  105. Enter the desired information into the Constant field. Enter "PRI".   Step 105
  106. Click the OK button.   Step 106
  107. Click the Add Criteria button.   Step 107
  108. Click the Select Record and Field button.   Step 108
  109. Click the Show Fields button.   Step 109
  110. Click the C.ADDRESS_TYPE - Address Type link.   Step 110
  111. Enter the desired information into the Constant field. Enter "MAIL".   Step 111
  112. Click the OK button.   Step 112
  113. Release the mouse button.   Step 113
  114. Click the Save Query button.   Step 114
  115. Enter the desired information into the Query field. Enter "TU_SR_DEANSLIST".   Step 115
  116. Enter the desired information into the Description field. Enter "FT deans list".   Step 116
  117. Click the Owner list.   Step 117
  118. Click the Public list item.   Step 118
  119. Enter the desired information into the Query Definition field. Enter "FT Deans List members prompted by term. ".   Step 119
  120. Click the OK button.   Step 120
  121. Release the mouse button.   Step 121
  122. Click the View SQL tab.   Step 122
  123. Click the Run tab.   Step 123
  124. Enter the desired information into the ENTER TERM field. Enter "1064".   Step 124
  125. Click the OK button.   Step 125

Table of Contents   Start Topic