Solved

Conditional Formatting at the Query View.

Posted on 2008-10-15
3
525 Views
Last Modified: 2013-11-29
Hi!
I need to make a conditional formatting of a query (using Expression Builder). I want to show the positive values with green and the negative with red. I don't want to use forms but only the default query result view of MS Access. Is it possible?
0
Comment
Question by:vfafou
  • 2
3 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 400 total points
ID: 22719258
Set the format for the column in the query to something like:
#.00[Green];#.00[Red]
0
 

Author Comment

by:vfafou
ID: 22719412
Thank you very much!
0
 

Author Closing Comment

by:vfafou
ID: 31506233
Thank you peter57r! That's exactly the solution I need!
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question