C
carriey
I hope this is an easy question. I have a Search Form with a very long SQL
statement which works perfectly as long as I have the following:
strWhere = "WHERE"
strOrder = "ORDER BY Tbl_MAIN.[Field_Location];"
However, I only want my List to return those records for a specific province
and I can't seem to get it to work. I have tried the following (and also
tried them with square brackets around Province) but I think that I am
misunderstanding how to use the quotes.
strWhere = "WHERE(((Tbl_Main.Province)="Alberta"));"
strWhere = "WHERE(((Tbl_Main.Province)='Alberta'));"
Could anyone tell me what I'm doing wrong? Thanks so much!
statement which works perfectly as long as I have the following:
strWhere = "WHERE"
strOrder = "ORDER BY Tbl_MAIN.[Field_Location];"
However, I only want my List to return those records for a specific province
and I can't seem to get it to work. I have tried the following (and also
tried them with square brackets around Province) but I think that I am
misunderstanding how to use the quotes.
strWhere = "WHERE(((Tbl_Main.Province)="Alberta"));"
strWhere = "WHERE(((Tbl_Main.Province)='Alberta'));"
Could anyone tell me what I'm doing wrong? Thanks so much!