If Statement Half Working

[DS]

I have this IIf statement set on the criteria part of a query...its in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the field,
otherwise if EndDay = anything but 8 the EndTime field should only
return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An

 

[Ofer]

this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

 

[DS]

this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

:

I have this IIf statement set on the criteria part of a query...its in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the field,
otherwise if EndDay = anything but 8 the EndTime field should only
return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An

This is a tough one! I'll try again. If the record in EndDay = 8, then
I want any record in EndTime to show up, otherwise I want only the
records in EndTime that are greater than Text11 to show up.

Does this make more sense?

Thanks
DS

 

[Ofer]

try that
IIf([EndDay]=8,[EndTime],>[Text11])

=IIf([EndDay]=8,[EndTime]) Or >IIf([EndDay]<>8,[Text11])

this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

:

I have this IIf statement set on the criteria part of a query...its in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the field,
otherwise if EndDay = anything but 8 the EndTime field should only
return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An

This is a tough one! I'll try again. If the record in EndDay = 8, then
I want any record in EndTime to show up, otherwise I want only the
records in EndTime that are greater than Text11 to show up.

Does this make more sense?

Thanks
DS

 

[fredg]

this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

I have this IIf statement set on the criteria part of a query...its in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the field,
otherwise if EndDay = anything but 8 the EndTime field should only
return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An

This is a tough one! I'll try again. If the record in EndDay = 8, then
I want any record in EndTime to show up, otherwise I want only the
records in EndTime that are greater than Text11 to show up.

Does this make more sense?

Thanks
DS

Try it this way:
=IIf([EndDay]=8,[EndTime],IIf([EndTime]>[Text11],[Endtime],""))

 

[tina]

in what context are you using the IIf() function? a query criteria? a query
calculated field? or a calculated control in a form?

If the record in EndDay = 8, then
I want any record in EndTime to show up

are EndDay and EndTime tables? or fields in a table? tables contain records
(rows) that consist of one or more fields (columns); fields contain values,
also called data elements. please use correct terminology, and more of an
explanation, to help us understand what you're trying to do.

this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

:

I have this IIf statement set on the criteria part of a query...its in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the field,
otherwise if EndDay = anything but 8 the EndTime field should only
return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An

This is a tough one! I'll try again. If the record in EndDay = 8, then
I want any record in EndTime to show up, otherwise I want only the
records in EndTime that are greater than Text11 to show up.

Does this make more sense?

Thanks
DS

 

[DS]

try that
IIf([EndDay]=8,[EndTime],>[Text11])

=IIf([EndDay]=8,[EndTime]) Or >IIf([EndDay]<>8,[Text11])

:

this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

:



I have this IIf statement set on the criteria part of a query...its in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the field,
otherwise if EndDay = anything but 8 the EndTime field should only
return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An

This is a tough one! I'll try again. If the record in EndDay = 8, then
I want any record in EndTime to show up, otherwise I want only the
records in EndTime that are greater than Text11 to show up.

Does this make more sense?

Thanks
DS

The Second One Works!!! Thanks...
I'm using it in SQL mode to populate a list, now the list the doesn't
populate, but when I run the Query that returns an answer. Well as they
say, onwards.
Once again.
Thank You
DS

 

[DS]

this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

:


I have this IIf statement set on the criteria part of a query...its in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the field,
otherwise if EndDay = anything but 8 the EndTime field should only
return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An

This is a tough one! I'll try again. If the record in EndDay = 8, then
I want any record in EndTime to show up, otherwise I want only the
records in EndTime that are greater than Text11 to show up.

Does this make more sense?

Thanks
DS

Try it this way:
=IIf([EndDay]=8,[EndTime],IIf([EndTime]>[Text11],[Endtime],""))

Thanks, I tried it but it didn't work. See the previous post.
Once again, thank you for helping.
DS

 

[DS]

in what context are you using the IIf() function? a query criteria? a query
calculated field? or a calculated control in a form?

If the record in EndDay = 8, then
I want any record in EndTime to show up

are EndDay and EndTime tables? or fields in a table? tables contain records
(rows) that consist of one or more fields (columns); fields contain values,
also called data elements. please use correct terminology, and more of an
explanation, to help us understand what you're trying to do.

this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

:



I have this IIf statement set on the criteria part of a query...its in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the field,
otherwise if EndDay = anything but 8 the EndTime field should only
return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An

This is a tough one! I'll try again. If the record in EndDay = 8, then
I want any record in EndTime to show up, otherwise I want only the
records in EndTime that are greater than Text11 to show up.

Does this make more sense?

Thanks
DS

Thanks Tina, see previous post.
DS

 

[Ofer]

Happy to help, its important to mark answer as the right answer, so others
with the same questions can use it.

try that
IIf([EndDay]=8,[EndTime],>[Text11])

=IIf([EndDay]=8,[EndTime]) Or >IIf([EndDay]<>8,[Text11])

:

Ofer wrote:

this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

:



I have this IIf statement set on the criteria part of a query...its in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the field,
otherwise if EndDay = anything but 8 the EndTime field should only
return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An


This is a tough one! I'll try again. If the record in EndDay = 8, then
I want any record in EndTime to show up, otherwise I want only the
records in EndTime that are greater than Text11 to show up.

Does this make more sense?

Thanks
DS

The Second One Works!!! Thanks...
I'm using it in SQL mode to populate a list, now the list the doesn't
populate, but when I run the Query that returns an answer. Well as they
say, onwards.
Once again.
Thank You
DS

 

[DS]

Happy to help, its important to mark answer as the right answer, so others
with the same questions can use it.

:

try that
IIf([EndDay]=8,[EndTime],>[Text11])

=IIf([EndDay]=8,[EndTime]) Or >IIf([EndDay]<>8,[Text11])

:



Ofer wrote:


this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

:




I have this IIf statement set on the criteria part of a query...its in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the field,
otherwise if EndDay = anything but 8 the EndTime field should only
return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An


This is a tough one! I'll try again. If the record in EndDay = 8, then
I want any record in EndTime to show up, otherwise I want only the
records in EndTime that are greater than Text11 to show up.

Does this make more sense?

Thanks
DS

The Second One Works!!! Thanks...
I'm using it in SQL mode to populate a list, now the list the doesn't
populate, but when I run the Query that returns an answer. Well as they
say, onwards.
Once again.
Thank You
DS

***THIS IS THE RIGHT ANSWER***

=IIf([EndDay]=8,[EndTime]) Or >IIf([EndDay]<>8,[Text11])

Once again, Thank you everyone.
DS

 

[adsl]

I have this IIf statement set on the criteria part of a query...its in the
EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the field,
otherwise if EndDay = anything but 8 the EndTime field should only return
the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An

 

[adsl]

this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

I have this IIf statement set on the criteria part of a query...its in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the field,
otherwise if EndDay = anything but 8 the EndTime field should only
return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An

 

[adsl]

this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

:

I have this IIf statement set on the criteria part of a query...its in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the field,
otherwise if EndDay = anything but 8 the EndTime field should only return
the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An

This is a tough one! I'll try again. If the record in EndDay = 8, then I
want any record in EndTime to show up, otherwise I want only the records
in EndTime that are greater than Text11 to show up.

Does this make more sense?

Thanks
DS

 

[adsl]

try that
IIf([EndDay]=8,[EndTime],>[Text11])

=IIf([EndDay]=8,[EndTime]) Or >IIf([EndDay]<>8,[Text11])

this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

:


I have this IIf statement set on the criteria part of a query...its in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the
field,
otherwise if EndDay = anything but 8 the EndTime field should only
return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An

This is a tough one! I'll try again. If the record in EndDay = 8, then
I want any record in EndTime to show up, otherwise I want only the
records in EndTime that are greater than Text11 to show up.

Does this make more sense?

Thanks
DS

 

[adsl]

try that
IIf([EndDay]=8,[EndTime],>[Text11])

=IIf([EndDay]=8,[EndTime]) Or >IIf([EndDay]<>8,[Text11])

:

Ofer wrote:

this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

:



I have this IIf statement set on the criteria part of a query...its in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the
field, otherwise if EndDay = anything but 8 the EndTime field should
only return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An


This is a tough one! I'll try again. If the record in EndDay = 8, then
I want any record in EndTime to show up, otherwise I want only the
records in EndTime that are greater than Text11 to show up.

Does this make more sense?

Thanks
DS

The Second One Works!!! Thanks...
I'm using it in SQL mode to populate a list, now the list the doesn't
populate, but when I run the Query that returns an answer. Well as they
say, onwards.
Once again.
Thank You
DS

 

[adsl]

Happy to help, its important to mark answer as the right answer, so others
with the same questions can use it.

try that
IIf([EndDay]=8,[EndTime],>[Text11])

=IIf([EndDay]=8,[EndTime]) Or >IIf([EndDay]<>8,[Text11])

:


Ofer wrote:

this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

:



I have this IIf statement set on the criteria part of a query...its
in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the
field,
otherwise if EndDay = anything but 8 the EndTime field should only
return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is
less
than Text11.
Any help is appreciated.
Thanks
DS

An


This is a tough one! I'll try again. If the record in EndDay = 8,
then
I want any record in EndTime to show up, otherwise I want only the
records in EndTime that are greater than Text11 to show up.

Does this make more sense?

Thanks
DS

The Second One Works!!! Thanks...
I'm using it in SQL mode to populate a list, now the list the doesn't
populate, but when I run the Query that returns an answer. Well as they
say, onwards.
Once again.
Thank You
DS

 

[adsl]

Happy to help, its important to mark answer as the right answer, so
others with the same questions can use it.

:

Ofer wrote:

try that
IIf([EndDay]=8,[EndTime],>[Text11])

=IIf([EndDay]=8,[EndTime]) Or >IIf([EndDay]<>8,[Text11])

:



Ofer wrote:


this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

:




I have this IIf statement set on the criteria part of a query...its
in the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the
field, otherwise if EndDay = anything but 8 the EndTime field should
only return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is
less than Text11.
Any help is appreciated.
Thanks
DS

An


This is a tough one! I'll try again. If the record in EndDay = 8,
then I want any record in EndTime to show up, otherwise I want only the
records in EndTime that are greater than Text11 to show up.

Does this make more sense?

Thanks
DS


The Second One Works!!! Thanks...
I'm using it in SQL mode to populate a list, now the list the doesn't
populate, but when I run the Query that returns an answer. Well as they
say, onwards.
Once again.
Thank You
DS

***THIS IS THE RIGHT ANSWER***

=IIf([EndDay]=8,[EndTime]) Or >IIf([EndDay]<>8,[Text11])

Once again, Thank you everyone.
DS

 

[adsl]

this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

:

I have this IIf statement set on the criteria part of a query...its in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the field,
otherwise if EndDay = anything but 8 the EndTime field should only
return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An

This is a tough one! I'll try again. If the record in EndDay = 8, then
I want any record in EndTime to show up, otherwise I want only the
records in EndTime that are greater than Text11 to show up.

Does this make more sense?

Thanks
DS

Try it this way:
=IIf([EndDay]=8,[EndTime],IIf([EndTime]>[Text11],[Endtime],""))

 

[adsl]

Ofer wrote:

this criteria doesnt make sense.

mybe what you tryng to get is

8 or >[text11]

:


I have this IIf statement set on the criteria part of a query...its in
the EndTime field...

=IIf([EndDay]=8,[EndTime],>[Text11])

If EndDay=8 then the EndTime field will return whatever is in the
field, otherwise if EndDay = anything but 8 the EndTime field should
only return the records with a value greater than the Text11 field.

It seems to only return the records of 8 when the EndTime field is less
than Text11.
Any help is appreciated.
Thanks
DS

An


This is a tough one! I'll try again. If the record in EndDay = 8, then
I want any record in EndTime to show up, otherwise I want only the
records in EndTime that are greater than Text11 to show up.

Does this make more sense?

Thanks
DS

Try it this way:
=IIf([EndDay]=8,[EndTime],IIf([EndTime]>[Text11],[Endtime],""))

Thanks, I tried it but it didn't work. See the previous post.
Once again, thank you for helping.
DS