conditional Format problem, second attempt

[Ron DeGregorio]

My first post didn't show the proper formatting.

I am using Access 2000
I have a table with a series of dates:
1/1/2005
6/1/2005
12/12/2005
1/1/2006

I have a query that reads:

SELECT [Date].[Date], Date() AS Expr1, [StatusDate] AS Expr2
FROM [Date]
ORDER BY [Date].[Date];

I have a report that gives today's date, Expr1; a status date, Expr2 (that I
enter on opening the report) and all the dates in the table field [Date] .
The field [Date] is listed twice in the detail portion of the report.

I have conditional formatting on the first column of [Date] to show in bold
type if the Expression is [Date]>[Expr1]

I have conditional formatting on the second column of [Date] to show in bold
type if the Expression is [Date]>[Expr2]

When I run the report I enter today's date in the Enter Parameter Value
window (12/10/2005).
The values for "Date() AS Expr1" and "[StatusDate] AS Expr2" should now be
the same but the report results are different for each column of [Date]
fields.

The results are:


12/10/2005 today's 12/10/2005 StatusDate:



1/1/2005 1/1/2005

6/1/2005 6/1/2005 (Bold)

12/12/2005 (Bold) 12/12/2005 (Bold)

1/1/2006 (Bold) 1/1/2006



Any idea of what is goining on here?

Ron

 

[Guest]

Ron

Perhaps your earlier post and Duane's reply crossed 'in the mail'.

If your table is named "Date", and your field is named "Date", and Access
has a function named "Date", the potential for confusion (yours AND Access')
is high. Change the names of things you can control (table, field) and avoid
using any of Access' reserved words. For example, "Time" is also a reserved
word!

Regards

Jeff Boyce
<Microsoft Offic/Access MVP>