They select from the available fields and set the criteria and for each criteria click ADD and it puts the criteria WHERE value in a List Box.
I'm running into an issue where this
which should be added as one line is appearing as 2 items in the List Box. The 2 lines look like this:FORMAT([Date],'YYYYMMDD') BETWEEN '20100503' AND '20100526'
andFORMAT([Date]
How do I get it to add the entire string to my List Box as one line?YYYYMMDD
My actual code is:
Code: Select all
Me.lstSelectedCriteria.AddItem "FORMAT([Date],'YYYYMMDD') BETWEEN '20100503' AND '20100526'"