#Error in Access

[Guest_imported]

Hello Folks

I would be interested to see if anyone else has experienced a similar problem to the one I found below. I'm far from being an Access expert but I can at least put together experissions in queries. I am currently working on a database where I was asked to return the left hand side of a string for a query, i.e. PostArea: Left([dbo_tbl_Stafflist]![Postcode],4). I was surprised that on running the query it returned a #Error value in each field in that column. Okay I figured I'd made an error, so I tried it on a differenct database, it worked fine? So I created a blank database and copied all the queries, reports, code, table etc, etc accross to this new database and bang, the query without any changes worked fine. Can anyone tell me what has caused this and how I can avoid it happening again?

Yours interestedly

Mike

 

[ghubbell]

Hi Mike, Is there a chance the expression builder built this one for you? I had another issue come through here this week and when re-typed by hand, worked fine. We've blamed it on Microsoft so please feel free to do the same. Built in Gremlins just to keep you busy! ;-) Gord
ghubbell@total.net