No matter what I do base does not like my use of wildcards with a parameter. This Like statement was copied from the help. I get an Invalid use of vertical bars.
Vertical bars couldn’t be used for every database. So: Which database engine do you use?
Linked to a Microsoft Access Database I created. Tables came over but not queries, forms, or reports.
Eddie
You could only link to the database, not to elements of GUI of Access. And this elements are forms, queries and reports.
I don’t know anything about Access, but might be you need something like CONCAT() instead of ||
"Surname"||', '||"Forename" will be the same as CONCAT("Surename",', ',"Forename")
Would you consider to add “this” statement go your question?
And please enclose it in backtics `
Ask/Guide - How to use the Ask site - The Document Foundation Wiki #Are_there_any_answers_to_my_question_yet?
Hi, I linked to a Microsoft Access Database I had created. Tables came over but not queries,forms or reports.
Eddie