Calculating Field in a Report

[tomohawk]

Hi, I'm a learner in Access (I'm using Access 2016) and also this is my first post to this forum, so apologies if I have repeated a question that has already been answered.



I have two issues I'm trying to get information on.

The output of my query is simply 2 columns:- Sales Area and Revenue. There is a total on the Revenue column.

My first issue is that there is one sales area with zero Revenue and this is not displaying.

My second issue is that I want to write a report based on the above query.

I want to write a report, but I want to add a new column "% of total" with 1 decimal place. This would be the individual sales area Revenue as a % of the total revenue.

Is there somewhere that gives step-by-step instructions on how to do this (I'm not a coder, so would need to be using the ribbon items)

T

[ranman256]

Use the Report builder wizard. It will guide you.

IF you want % then you need a second query that has total, add this query into your report query (no join)
This way you have the total on every record, and you can calc % on each record.

[tomohawk]

Thanks ranman256 Attached is my simple database.

I want to add a new column (for each sales area) to the output which is % Total (income/overall total income) as a percentage.

I go to the builder and I cannot find "total income" anywhere.

T

[tomohawk]

I will now close this due to lack of interest