A
adsl
tina said:
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
adsl
DS said:Thanks Tina, see previous post.tina said: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.
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
DS
A
adsl
Ofer said:this criteria doesnt make sense.
mybe what you tryng to get is
8 or >[text11]
DS said: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
A
adsl
adsl said:DS said: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
A
adsl
adsl said:Ofer said:this criteria doesnt make sense.
mybe what you tryng to get is
8 or >[text11]
DS said: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
A
adsl
adsl said:Ofer said:this criteria doesnt make sense.
mybe what you tryng to get is
8 or >[text11]
DS said: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
A
adsl
adsl said:DS said: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
A
adsl
adsl said:Ofer said:this criteria doesnt make sense.
mybe what you tryng to get is
8 or >[text11]
DS said: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
A
adsl
adsl said:Ofer said:this criteria doesnt make sense.
mybe what you tryng to get is
8 or >[text11]
DS said: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
A
adsl
adsl said:DS said:This is a tough one! I'll try again. If the record in EndDay = 8, thenOfer said: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
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
A
adsl
adsl said:tina said: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.
DS said: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
A
adsl
adsl said:DS said:Thanks Tina, see previous post.tina said: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.
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
DS
A
adsl
DS said:Thanks Tina, see previous post.tina said: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.
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
DS
A
adsl
tina said: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.
DS said:This is a tough one! I'll try again. If the record in EndDay = 8, thenOfer said: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
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
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.