Re: Substituting Data on Reports

Tech-Archive recommends: Speed Up your PC by fixing your registry

You understand "Signed" is the higest priority but if I look at your data,
can I determine that? Is there anything in your tables that states Signed is
higher than New?

I am also confused regarding just showing one value. Do you want to filter
out some records? Perhaps you could provide some sample records...

--
Duane Hookom
Microsoft Access MVP


"JoeD via AccessMonster.com" wrote:

Klatuu wrote:
You could use a calculated field in your report's record source query or you
can do it directly in the control source of the text box where you present
the value. I would do the calculation in the report.

Look in VBA Help for the Switch function. I believe it will do what you are
asking.

Hello:

[quoted text clipped - 5 lines]

Thanks

Thanks! That did it. I manipulated the query. Now I need to find a way
just to display one of them. For example, if I have "Signed", "In-Work",
"New" and "Signed" is the highest priority showing in the query, I need to
find a way to show that in a text box. Any ideas?

--
Message posted via http://www.accessmonster.com


.

Relevant Pages