Jan 10 2021 04:39 PM - edited Jan 10 2021 04:41 PM
When extracting data from a database, I have some data that shows up as "LEI & EI" and when I try to search it using a countif formula it doesn't allow me. Is there a way to state in the criteria box for it to recognize the "&" sign with the word?
Nov 25 2023 04:09 PM
Not very elegant but my quick solution was to export to Excel and then do a Replace All "&" -> "and" and then put back into Access