Display Access Query Result in report

Question

I have a query in Access to calculate the percentage. It displays the desired result in the Datasheet View. When I try to put that result in a report using text box, it shows 0.

I have nine text boxes with different query results which also show their data in datasheet view. When it comes to report only one textbox shows a result, the others show 0.

I googled and found nothing. Every setting and formatting checked multiple times.

Query result in datasheet view

Report view using query result shows 0

Answer 1

I presume you have these textboxes in a report header or footer section which is displaying only first record data. Assuming this dataset has only these 5 records and you want them displayed as a single record in report, use =Max([fieldname]) in each textbox - referencing appropriate fieldname of course.

If there are actually multiple groups of data, then put textboxes in a group section and use that same expression.