conditional format problem

R

Ron DeGregorio

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

12/12/2005 12/12/2005

1/1/2006 1/1/2006



Any idea of what is goining on here?

Ron
 
D

Duane Hookom

I wouldn't go any further until the names were fixed. You have a table and a
field with the same name (which is a function name). You don't alias your
columns with descriptive names. Is [StatusDate] a parameter prompt? If so,
it would be common to use a parameter like: [Enter Status Date].

What date values/columns are you showing in your final output?
 
R

Ron DeGregorio

Yes, [StatusDate] is a parameter prompt.

My last post didn't show the bold formatting that was returned. It looked
like this:

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

Wouldn't you expect both columns to be identical?

Could the cause of the problem be that I didn't alias my columns with
descriptive names or the I didn't use [Enter Status Date] instead of
[StatusDate]?

Duane Hookom said:
I wouldn't go any further until the names were fixed. You have a table and a
field with the same name (which is a function name). You don't alias your
columns with descriptive names. Is [StatusDate] a parameter prompt? If so,
it would be common to use a parameter like: [Enter Status Date].

What date values/columns are you showing in your final output?

--
Duane Hookom
MS Access MVP
--

Ron DeGregorio said:
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

12/12/2005 12/12/2005

1/1/2006 1/1/2006



Any idea of what is goining on here?

Ron
Click to expand...
Click to expand...
 
D

Duane Hookom

It could be the fee assessed from lack of proper names. You also might need
to wrap your [StatusDate] in the CDate() function.

--
Duane Hookom
MS Access MVP
--

Ron DeGregorio said:
Yes, [StatusDate] is a parameter prompt.

My last post didn't show the bold formatting that was returned. It looked
like this:

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

Wouldn't you expect both columns to be identical?

Could the cause of the problem be that I didn't alias my columns with
descriptive names or the I didn't use [Enter Status Date] instead of
[StatusDate]?

Duane Hookom said:
I wouldn't go any further until the names were fixed. You have a table
and a
field with the same name (which is a function name). You don't alias your
columns with descriptive names. Is [StatusDate] a parameter prompt? If
so,
it would be common to use a parameter like: [Enter Status Date].

What date values/columns are you showing in your final output?

--
Duane Hookom
MS Access MVP
--

Ron DeGregorio said:
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

12/12/2005 12/12/2005

1/1/2006 1/1/2006



Any idea of what is goining on here?

Ron
Click to expand...
Click to expand...
Click to expand...
 
J

Jeff Boyce

Ron

The parameter/prompt that you use is for Access' benefit, and has nothing to
do with an alias you might use for the name of the field.

--
Regards

Jeff Boyce
<Office/Access MVP>

Ron DeGregorio said:
Yes, [StatusDate] is a parameter prompt.

My last post didn't show the bold formatting that was returned. It looked
like this:

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

Wouldn't you expect both columns to be identical?

Could the cause of the problem be that I didn't alias my columns with
descriptive names or the I didn't use [Enter Status Date] instead of
[StatusDate]?

Duane Hookom said:
I wouldn't go any further until the names were fixed. You have a table
Click to expand...
and
a
field with the same name (which is a function name). You don't alias your
columns with descriptive names. Is [StatusDate] a parameter prompt? If so,
it would be common to use a parameter like: [Enter Status Date].

What date values/columns are you showing in your final output?

--
Duane Hookom
MS Access MVP
--

Ron DeGregorio said:
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
Click to expand...
Click to expand...
[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
Click to expand...
Click to expand...
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

12/12/2005 12/12/2005

1/1/2006 1/1/2006



Any idea of what is goining on here?

Ron
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional Format problem, second attempt 1
Conditional Formatting question.... 1
Dates not sorting correctly in Report 9
Calc Number of Months PER YEAR Between Dates 2
Problem formatting dates from CSV file 2
Field in a report 2
SQL query with join on substring 5
VBA - exporting serial letters to single documents 0

Top