I have a report listing scores of tests taken, so an employee can have many 
test scores. I have already created a text box called txtCount so that only 
the two recent scores are displayed. What I want to see, if the most recent 
score is less than their previous score, to colour it red. Can I achieve 
this? I'm using 2003

Thanks

Nigel

I expect you need to get the two scores returned in the same record/row of 
the report's record source. This is typically accomplished with a subquery or 
similar.

-- 
Duane Hookom
Microsoft Access MVP


"Nigel" wrote:

> I have a report listing scores of tests taken, so an employee can have many 
> test scores. I have already created a text box called txtCount so that only 
> the two recent scores are displayed. What I want to see, if the most recent 
> score is less than their previous score, to colour it red. Can I achieve 
> this? I'm using 2003
> 
> Thanks
> 
> Nigel

Thanks for your reply. How would I do this, please.

Thanks

"Duane Hookom" wrote:

> I expect you need to get the two scores returned in the same record/row of 
> the report's record source. This is typically accomplished with a subquery or 
> similar.
> 
> -- 
> Duane Hookom
> Microsoft Access MVP
> 
> 
> "Nigel" wrote:
> 
> > I have a report listing scores of tests taken, so an employee can have many 
> > test scores. I have already created a text box called txtCount so that only 
> > the two recent scores are displayed. What I want to see, if the most recent 
> > score is less than their previous score, to colour it red. Can I achieve 
> > this? I'm using 2003
> > 
> > Thanks
> > 
> > Nigel

You could search the web on "Ranking subQuery query" or reply back with your 
table structure, the data types, some sample records, and desired output.

Duane Hookom
MS Access MVP

"Nigel" <Nigel@discussions.microsoft.com> wrote in message 
news:A86DEFFA-7C5C-40D8-8E68-E5BE0D3FF4F3@microsoft.com...
> Thanks for your reply. How would I do this, please.
>
> Thanks
>
> "Duane Hookom" wrote:
>
>> I expect you need to get the two scores returned in the same record/row 
>> of
>> the report's record source. This is typically accomplished with a 
>> subquery or
>> similar.
>>
>> -- 
>> Duane Hookom
>> Microsoft Access MVP
>>
>>
>> "Nigel" wrote:
>>
>> > I have a report listing scores of tests taken, so an employee can have 
>> > many
>> > test scores. I have already created a text box called txtCount so that 
>> > only
>> > the two recent scores are displayed. What I want to see, if the most 
>> > recent
>> > score is less than their previous score, to colour it red. Can I 
>> > achieve
>> > this? I'm using 2003
>> >
>> > Thanks
>> >
>> > Nigel 

Hi Duane

I'll try searching first, I'll enjoy the challenge of finding out!

Many thanks.

Nigel

"Duane Hookom" wrote:

> You could search the web on "Ranking subQuery query" or reply back with your 
> table structure, the data types, some sample records, and desired output.
> 
> Duane Hookom
> MS Access MVP
> 
> "Nigel" <Nigel@discussions.microsoft.com> wrote in message 
> news:A86DEFFA-7C5C-40D8-8E68-E5BE0D3FF4F3@microsoft.com...
> > Thanks for your reply. How would I do this, please.
> >
> > Thanks
> >
> > "Duane Hookom" wrote:
> >
> >> I expect you need to get the two scores returned in the same record/row 
> >> of
> >> the report's record source. This is typically accomplished with a 
> >> subquery or
> >> similar.
> >>
> >> -- 
> >> Duane Hookom
> >> Microsoft Access MVP
> >>
> >>
> >> "Nigel" wrote:
> >>
> >> > I have a report listing scores of tests taken, so an employee can have 
> >> > many
> >> > test scores. I have already created a text box called txtCount so that 
> >> > only
> >> > the two recent scores are displayed. What I want to see, if the most 
> >> > recent
> >> > score is less than their previous score, to colour it red. Can I 
> >> > achieve
> >> > this? I'm using 2003
> >> >
> >> > Thanks
> >> >
> >> > Nigel 
>