Query is not returning data....

[jeffmoore]

Below is the query i'm tring to run. The query works fine in all regards except when i put 'Like "*"' in to the true part, then the query returns Zero records Instead of all the records. I have checked the 'IsNull' expression using the Immeadeate window of VBA and my expresion DOES return a null where it should .... HELP...

IIf(IsNull([Forms]![ReturnedGoodsrpt]![Customer]),Like "*",[Forms]![ReturnedGoodsrpt]![Customer])

TIA
jeff

 

[lespaul]

The way you are using the LIKE operator it will return all records where it finds a '*' in the field. What does the rest of your query look like?

 

[bitbuster]

Jef,

Just replace the 'like "*"' with the name of the field you try to display and it should work fine.

Regards,

Bitbuster

 

[jeffmoore]

I solved it...

Like (IIf(IsNull([Forms]![ReturnedGoodsrpt]![Customer]),"*",[Forms]![ReturnedGoodsrpt]![Customer]))

Returns the correct data...

Thanks for the help
jeff