Microsoft Access cannot represent the expression of the combination

[bladu]

Hi,

I have the following query:

SELECT DISTINCT C1.Revision, C1.Fecha_ult_revision


FROM Control AS C1 INNER JOIN Control AS C2 ON C1.Revision<C2.Revision
WHERE (((C1.Numero)=[Num]) AND ((C1.Hoja)=[hoj]))
ORDER BY C1.Revision;

In Mysql runs well, and takes out the correct result. But trying the same in Access, the result is not the correct and after executing the query if I try to go to the preview view, it gives me the following message error:

Microsoft Access cannot represent the expression of the combination C1.Revision < C2.Revision in the preview view.

Are symbols like < or > possible in Access queries?

[dcrake]

There are naming convention issues here. Using words such as Control, Num & Revision are suspect. With regard to your < what are you attempting to acheive?

David