FLAGGING SYSTEM

Hope someone out there can help.

I have created a database which holds clients information of
assessments they have had. I have also created a simple query which
will let me know that that person is due another assessment in 2
months time:

Month(DateAdd("m",2,Date()))

However, I would also like the query to tell me people due in 3 months
time but place there data in another colour, i.e., red. Is this
possible?

Many thanks to anyone who can help

stu

You didn't indicate what version of Access you're using, but if it's Access
2000 or greater look into Conditional Formatting ... this allows you to set
certain colors and such of your form controls dependant on the
value/conditions of the underlying data.

--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP
"Stuart Masters" <stuart.masters@pcs-tr.swest.nhs.uk> wrote in message
news:60fe95cc.0401160329.73cc3c35@posting.google.c om...[color=blue]
> Hope someone out there can help.
>
> I have created a database which holds clients information of
> assessments they have had. I have also created a simple query which
> will let me know that that person is due another assessment in 2
> months time:
>
> Month(DateAdd("m",2,Date()))
>
> However, I would also like the query to tell me people due in 3 months
> time but place there data in another colour, i.e., red. Is this
> possible?
>
> Many thanks to anyone who can help
>
> stu[/color]

Sorry

I'm using Access 97


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

On 16 Jan 2004 13:49:24 GMT, Stuart Masters
<stuart.masters@pcs-tr.swest.nhs.uk> wrote in
comp.databases.ms-access:
[color=blue]
>I'm using Access 97[/color]

To change the color of a column in Access 97 queries, just select the
column in the query designer and right click and choose properties,
then on the 'General' tab of the popup properties dialog, under
'Format', type

[color]X

where 'color' is the desired color and 'X' is the desired format. So,
if dates are being displayed, and you wanted the query to display
green text, you could type

[green]m/d/yy

for example.

This formats the entire column in the selected color. To format just
certain values, you could, for instance, set a flag column with a
calculated field (something along the lines of

isOverdue: [DueDate]<now()

then in the format field, use something like

"Ok";[red]"Late!"

This would flag, in red, the overdue rows, and leave the non-overdue
rows in black.

You get the picture.

Scott mentioned conditional formatting in forms in Access 200 and
later, but the conditional color formatting works in earlier versions
too, and works for queries directly, and not just forms/reports.


Peter Miller
__________________________________________________ __________
PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
Free quotes, Guaranteed lowest prices and best results
www.pksolutions.com 1.866.FILE.FIX 1.760.476.9051