Support required in msaccess report

[everwelwisher]

Dear friends!

I have a access report with the following fields


date_inv order_amount invoice_amount remaining_balance
15-08-2015 50,000 15000 35000



i want to hide order amount to appear in my report from 2nd row and onward

i just need to display it on first row..

How to do it

thanks

nida

[June7]

Try textbox HideDuplicates property.

[everwelwisher]

thanks it works .. now

how to take sum of only visible cells ???
in access report

[June7]

There is only one 'cell' (textbox). Cells is a spreadsheet term. Must abandon spreadsheet concepts when working with a relational database.

Options:

1. an aggregate query that sums the OrderAmount field, then join that query to the raw dataset

2. report/subreport arrangement

3. DSum() domain aggregate function calc in textbox