How to express a string, inside a string, inside a string?

  • Thread starter Thread starter JethroUK©
  • Start date Start date
J

JethroUK©

"'College Completers','Month([L1 submitted]=3 AND [Provider]= COL'"

i need to express the word "COL" as a string part of Where statement, in
turn the Where statement has to be expressed as a string to populate a combo
box

p.s. this is only very small part of a large string populating 10 rows x 2
cols of a combo box - everything works fine except the word "COL"
 
JethroUK© said:
"'College Completers','Month([L1 submitted]=3 AND [Provider]= COL'"

i need to express the word "COL" as a string part of Where statement, in
turn the Where statement has to be expressed as a string to populate a combo
box

p.s. this is only very small part of a large string populating 10 rows x 2
cols of a combo box - everything works fine except the word "COL"
Click to expand...

"'College Completers','Month([L1 submitted]=3 AND [Provider]= ''COL'''"
 
MGFoster said:
JethroUK© said:
"'College Completers','Month([L1 submitted]=3 AND [Provider]= COL'"

i need to express the word "COL" as a string part of Where statement, in
turn the Where statement has to be expressed as a string to populate a combo
box

p.s. this is only very small part of a large string populating 10 rows x 2
cols of a combo box - everything works fine except the word "COL"
Click to expand...

"'College Completers','Month([L1 submitted]=3 AND [Provider]= ''COL'''"
Click to expand...

i've broken it down to short string:

Filter = "'College Completers','Month([L1 submitted]=3 AND [Provider]=
''COL''' "

but it still errors - 'object cant be assigned'

any more clues?
 
JethroUK© said:
MGFoster said:
JethroUK© said:
"'College Completers','Month([L1 submitted]=3 AND [Provider]= COL'"

i need to express the word "COL" as a string part of Where statement, in
turn the Where statement has to be expressed as a string to populate a combo
box

p.s. this is only very small part of a large string populating 10 rows
Click to expand...
Click to expand...
x
2
cols of a combo box - everything works fine except the word "COL"
Click to expand...

"'College Completers','Month([L1 submitted]=3 AND [Provider]= ''COL'''"
Click to expand...

i've broken it down to short string:

Filter = "'College Completers','Month([L1 submitted]=3 AND [Provider]=
''COL''' "

but it still errors - 'object cant be assigned'

any more clues?
Click to expand...

actually spotted the problem - missing closing bracket on Month function - i
still used your solution, so thanks anyway
 
Back
Top