"Unknown" message error while opening a query

[falahsalih]

Hi,
when I open a query whether by double click or command button, the following error appears





what does it mean ?? this error appears sometimes not always. Can any help please.!!!
I can't figure out what this error refers to, as long as there no any error description or code.

[June7]

I have never seen that error.

Can you open the query in Design View or SQL View?

Post the SQL statement for analysis.

[falahsalih]

I have never seen that error.

Can you open the query in Design View or SQL View?

Post the SQL statement for analysis.

yes, I can open the query in design view

Sql

SELECT customers.[Costumer Name], order.[Order ID], Last(payments.PYMDate) AS LastOfPYMDate, DateAdd('d',30,[PYMDate]) AS [Planned Payment], Abs(DateAdd('d',30,[PYMDate])-Date()) & " " & "Days" AS [Days Passed]
FROM (customers INNER JOIN [order] ON customers.CustomerID = order.[Customer ID]) INNER JOIN payments ON order.[Order ID] = payments.[Order ID]
GROUP BY customers.[Costumer Name], order.[Order ID], DateAdd('d',30,[PYMDate]), Abs(DateAdd('d',30,[PYMDate])-Date()) & " " & "]Days", customers.CustomerID
HAVING (((DateAdd('d',30,[PYMDate]))<=Date()));

[June7]

The Abs() expression in the GROUP BY has an extra ] in front of Days.

There is also an unnecessary concatenation in both of the Abs() expressions but that should not cause error.

Abs(DateAdd('d',30,[PYMDate])-Date()) & " Days"

[falahsalih]

The Abs() expression in the GROUP BY has an extra ] in front of Days.

There is also an unnecessary concatenation in both of the Abs() expressions but that should not cause error.

Abs(DateAdd('d',30,[PYMDate])-Date()) & " Days"

If there is a syntax or expression error, so why this error disappear sometimes ?

[ItsMe]

That looks like a MsgBox to me. Are you sure you are opening a query object?

[falahsalih]

If there is a syntax or expression error, so why this error disappear sometimes ?

Yes, I'm sure. I believe that the problem lies in the query structure, because i'm doing many nested expressions in it.
Can I re-form the query using sql ?

[June7]

I have no idea why the error would be intermittent.

Maybe use "d" instead 'd'.

That is SQL.