Using Between and And in String Criteria (1 Viewer)

[Ray Spackman]

Okay I was working on this earlier and had it correct but then had to make some changes and lost the correct syntax and for the life of me cannot remember how I had it. Here is what I currently have which incorrect:

strWhere = strWhere & "([RG]= between """ & Me.cmbRG1 & """ And """ & Me.cmbRG2 & """ ) AND "

Can someone please tell me where the "between" should acutally be.

Thank You.

 

[RainLover]

You can't finiish with "AND"

 

[Ray Spackman]

That "AND" is for something else and doesn't pertain to what i am trying to accomplish with in the parantheses. I can assure you that you can finish with an and. But thank you any I have found a work around. Incidentally here is the link to show that you can use AND at the end; it may be educational.

http://allenbrowne.com/ser-62code.html

 

[RainLover]

I can assure you that you can finish with an and. But thank you any I have found a work around. Incidentally here is the link to show that you can use AND at the end; it may be educational.

http://allenbrowne.com/ser-62code.html

It is a shame you don't know how to read.

If you did you would see that the "AND" gets chopped off.

'***********************************************************************
'Chop off the trailing " AND ", and use the string as the form's Filter.
'***********************************************************************

Suggest you go back. To school that is and learn some manners.