Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
i have table T1 with query, name
T2 table pattern , category
Query can be anything
t2 table
pattern2 category
connection*failure* connectivity
power*failure* power issue
i am trying like
select t1.query, t2.patter,t2.category from t1,t2 where query like "*"&t2.pattern2&"*"
but in MS access it says join does not suppport expression . how to achieve this.
Hi @vijaykaali811 ,
Thanks for reaching out to the Microsoft fabric community forum.
Thanks for sharing your question here Since your issue seems to be related specifically to pattern matching in MS Access queries, I’d recommend also posting this thread in the Microsoft Access Community. There are many experienced Access developers and experts there who are more focused on Access-specific syntax and behaviour they may be able to offer more targeted assistance.
Database Software and Applications | Microsoft Access
Best Regards,
Lakshmi Narayana