Prev: Time cell with colons
Next: Does anyone help me to learn German languages ?
From: KenSheridan via AccessMonster.com on 14 Feb 2010 16:05
I interpret it differently on the basis that:

(a) they'd included column headings.
(b) they'd said 'the field that contains the "value" of the
test results', with "value" apparently emphasised.

but you could be right. Hopefully they'll clarify.

Ken Sheridan
Stafford, England

Tom Wickerath wrote:
>Hi Ken,
>
>> WHERE Test-Type = "Platelet count"
>> AND Val([Test-Value]) < 100
>> AND IsNumeric([Test-Value])
>
>Doesn't this assume that the OP has a field named "Test-Type"? My
>understanding is that ALL of his data is in one memo-type field.
>
>Tom Wickerath
>Microsoft Access MVP
>http://www.accessmvp.com/TWickerath/
>__________________________________________
>
>> The Val function won't produce an error if applied to a non-numeric text
>> value; it will return a zero in fact. So for the example you've cited you
>[quoted text clipped - 14 lines]
>> Ken Sheridan
>> Stafford, England

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/201002/1

From: kejo41 on 14 Feb 2010 20:39
Hi Ken,

You are right each column heading represents a different field. The "problem
field" is only the test-value field (which containes everything under the
sun). I will certainly try this tommorrow at work.

Tom: Sorry for the poor wording, I appreciate your input as well.


KeJo41

"KenSheridan via AccessMonster.com" wrote:

> I interpret it differently on the basis that:
>
> (a) they'd included column headings.
> (b) they'd said 'the field that contains the "value" of the
> test results', with "value" apparently emphasised.
>
> but you could be right. Hopefully they'll clarify.
>
> Ken Sheridan
> Stafford, England
>
> Tom Wickerath wrote:
> >Hi Ken,
> >
> >> WHERE Test-Type = "Platelet count"
> >> AND Val([Test-Value]) < 100
> >> AND IsNumeric([Test-Value])
> >
> >Doesn't this assume that the OP has a field named "Test-Type"? My
> >understanding is that ALL of his data is in one memo-type field.
> >
> >Tom Wickerath
> >Microsoft Access MVP
> >http://www.accessmvp.com/TWickerath/
> >__________________________________________
> >
> >> The Val function won't produce an error if applied to a non-numeric text
> >> value; it will return a zero in fact. So for the example you've cited you
> >[quoted text clipped - 14 lines]
> >> Ken Sheridan
> >> Stafford, England
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access/201002/1
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Time cell with colons
Next: Does anyone help me to learn German languages ?