openreport and wherecondition with Like in it

[sbdproj]

Hi, can't preview my report when I use a wherecondition in which I use the word "LIKE" .
Who knows how to do this.

This is a part of my code:
dim wherecondition as string

wherecondition = "[Kal_date] = 'Like 2003*'"
DoCmd.OpenReport stDocName, acPreview, , wherecondition

 

[RoyVidar]

Try:

[tt]dim strWhereCondition as string
strWhereCondition = "[Kal_date] Like '2003*'"[/tt]

i e - placement of the single quote, Like operator works without equal sign, and I think wherecondition is the name of the condition, better use another name/naming convention.

Roy-Vidar

 

[sbdproj]

thanx, it works fine now!