J
JOJ via AccessMonster.com
I have a check box named DTCLOSE2 in my dialogue form.If checked, the
query to filter all records including nulls otherwise filter those
records which matches the date inputted in the field DTCLOSE.
Could you pls debug the following criteria so that my query works as
per the logic above.I think it is something to do with the string
concatenation.
Query criteria on a date field:
IIf(([Forms]![All Shipment Status]![DTCLOSE2]=-1),([dbo_tblShipment].
[ActualArrivalin]) Like "*" Or ([dbo_tblShipment].[ActualArrivalin]) Is Null,
([dbo_tblShipment].[ActualArrivalin]) Like [Forms]![All Shipment Status]!
[DTCLOSE])
query to filter all records including nulls otherwise filter those
records which matches the date inputted in the field DTCLOSE.
Could you pls debug the following criteria so that my query works as
per the logic above.I think it is something to do with the string
concatenation.
Query criteria on a date field:
IIf(([Forms]![All Shipment Status]![DTCLOSE2]=-1),([dbo_tblShipment].
[ActualArrivalin]) Like "*" Or ([dbo_tblShipment].[ActualArrivalin]) Is Null,
([dbo_tblShipment].[ActualArrivalin]) Like [Forms]![All Shipment Status]!
[DTCLOSE])