i have the following query but it doesnt produe any results:

Me.OleDbCommand1.CommandText = "Select * From Emp Where Week='WeekString'"

is this valid syntax when using the WHERE part of a sql query

WeekString is just a string that takes its value from a txtbox on a form