Why does this Q return an #Error????

[shkrebs]

I've must have turned blind because I can't see what's wrong...

The field C Postal is an textfield.

SELECT DISTINCTROW Left([C postal],2) AS zip, [Ventas de postales].[C postal]
FROM [Ventas de postales];

Best regards
El Vikingo

 

[David R]

Check your references

Under Tools>References, make sure nothing is 'MISSING'. Usually when basic Access functions start wigging out that is the cause.

Check the archives for 'missing references' to find out more about this phenomenon (I've never experienced it, personally).

 

[shkrebs]

Thanks - I was a little quick I think - sorry :-( , 'cause the problem is only in this database so I have to find the ghost here and not in the system.

Best regards
Soren Herman Krebs

 

[shkrebs]

Thanks - I was a little quick I think - sorry :-( , 'cause the problem is only in this database so I have to find the ghost here and not in the system.

Best regards
Soren Herman Krebs

 

[David R]

Did you try rebuilding the query?

If it's not a Missing Reference, I'm out of ideas. I created a query practically identical to yours, and it worked fine:

SELECT DISTINCTROW Left([ParticipantID],2) AS zip, BackuptableParticipants.ParticipantID
FROM BackuptableParticipants;