Microsoft access errors

Question

If I run a query in ms access and receive errors in running the query. I clicked the help popup. If the help popup does not help me debug the query, what other resources can I use?

Answer 1

Maybe you should remove these characters at the end: ") b".

Answer 2

SELECT max_exam.nfa_id AS nfa_id2,
fm.matter_number AS exam_id,
fm.matter_open_date,
max_exam.matter_close_date
FROM facts_matter fm
right join (
select e.matter_number, e.nfa_id, f.matter_close_date from
(select Max(c.matter_number) AS matter_number,
d.nfa_id
FROM
(select matter_number, matter_open_date, matter_close_date
from facts_matter
WHERE matter_number LIKE '%DEXM%'
and matter_open_date < TO_DATE('20220601','YYYYMMDD')) c
left join
(SELECT matter_number, nfa_id
FROM facts_matter_party
WHERE matter_number LIKE '%DEXM%') d
on c.matter_number = d.matter_number
GROUP BY d.nfa_id) e
left join
(select matter_number, matter_close_date
from facts_matter
WHERE matter_number LIKE '%DEXM%') f
on e.matter_number = f.matter_number
) max_exam
ON fm.matter_number = max_exam.matter_number) b

@xps350 @Ceasar Chen_MSFT