As you can see that “Filter” query counts the repetition of each string.
What I want to do is to create another table with this query and do some access vba that changes the string in each record of the newly created table like this:
So in essence, I am actually appending [http://
] in the beginning and [.aspx] at the end of each record in a newly created table, along with the count column.
How that can be done in access vba? Please assist.