Displaying a newly created field in a Query to a Report

T

Terry Hollands

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?
 
K

Ken Snell MVP

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't create a report from my query in Access 1
Update Query 3
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Add "Record Created On" Field to a Query 5
Access Access Report Works on One Machine but not Another 3
Searching for Records in a Report 1
"stretch-to-fit" text box for Report 2
Report Header/title from unmatched query 1

Top