Light up information

  • Thread starter Thread starter PIBE
  • Start date Start date
P

PIBE

I´m developing an application at access, in need to light up some records
according to some percentage defined by the user. For example, I want to
remark the records with the values that represents the 80% of the incomes. In
excel I can use the conditional formatting tool over a column with the
calculated percentage, but in access I have not found how to use the total
value of the reports neither how to use the percentposition property of the
table.
Any help or idea will be welcome, thanks in advance.
 
I´m developing an application at access, in need to light up some records
according to some percentage defined by the user. For example, I want to
remark the records with the values that represents the 80% of the incomes. In
excel I can use the conditional formatting tool over a column with the
calculated percentage, but in access I have not found how to use the total
value of the reports neither how to use the percentposition property of the
table.
Any help or idea will be welcome, thanks in advance.
Click to expand...

Access also has a Conditional Formatting feature (under the Format menu item).
It's not at all clear how your data is structured though. More info please!
 
The table contains the fields: year, period, product name, market segment,
product price, product price of the market segment, total sales, cash income,
credit sales.
How can I light up all the records that represents the 80% of the total
using as reference the total sales field?
I know how to use the conditional formating tool, but I do not know how can
I related the tool with a specif percentage. The table itself does not
contains a percentage field and I do not know how to create it.
I do not know how to use the total of the field, I have been able to display
the total inside report and query, but I do not know how to use it inside a
query to create the percentage field.
Thanks...
 
Back
Top