Changing colours

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks very much to Allen Browne who helped with the following SQL View:
SELECT (SELECT Max([DateOfService]) FROM tblSales WHERE tblSales.SiteID =
[T4-Sites].SiteID) AS LastSale, [T4-Sites].SiteID
FROM [T4-Sites];

I would like the "LastSale" field to be red if date is older than 14 days.
The field is not brought into a form using a control rather is part of a row
source/column so conditional fomatting wont work.
As part of this we would actually like older than 14 days =red, older than
30 days = Blue etc etc

Please help if you can

Daniel
 
Hi,


That kind of formatting is preferably done in a form (with conditional
formatting, as example), rather than with SQL (and the possibility to get
color with the VBA function Format( ) ).


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top