If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Displaying a newly created field in a Query to a Report
A college needs to give students a refund of 0.05 to students on certain
courses. I have created a query and included a new field to calculate the refund. The query works OK when I run it but if I try to create a report and add this new field it does not display in the report. Any suggestions? -- Terry Hollands |
#2
|
|||
|
|||
Displaying a newly created field in a Query to a Report
Add a textbox to the report, and set the Control Source property to the name
of that new field from your query. Also, check the Record Source property of the report; if it's not the name of the query that you created, change it to that new name. -- Ken Snell MS ACCESS MVP http://www.accessmvp.com/KDSnell/ "Terry Hollands" wrote in message ... A college needs to give students a refund of 0.05 to students on certain courses. I have created a query and included a new field to calculate the refund. The query works OK when I run it but if I try to create a report and add this new field it does not display in the report. Any suggestions? -- Terry Hollands |
Thread Tools | |
Display Modes | |
|
|