Recent content by DaveBerube

That's why I probably shouldn't have answered, I mostly use the interface, it would be pretty easy there, but I don't know how to translate that to SQL.

You should be able to do an update query linked to EDM to update the coordinates in Lokacija to the Coordinates in Edm2012

Probably not the one to provide answers, but. You can just add another link between the table with the code and the code description table and pull in the description in the same query.

After typing up a whole response explaining how that didn't work and why I didn't understand it I guess I explained it to myself. Now I even understand what Bill was saying. It was an addition to replace the the field once I defined the expression. What I ended up with was doing an update...

I can't post pictures yet, but I guess I can post the SQL. This is how my orginal request looked in SQL. I'm pretty sure I must be putting it in the wrong place or something. Seems it should be an update Query, but that's not what the instructions I found showed. SELECT...

Sorry to be such a pain, but how do I 'drop' it into the query interface? Does it go in the field row as an expression in a select query or in the 'update to' row of an update query?

Does that work in a select query interface or do I need to go into SQL view? I'm not getting non wildcards to work so I'm pretty sure I'm just doing something stupid. I can't post screen shots, but I'm putting the expression in the field row of the query interface and using a select query. I...

What do you mean regular expressions?

First post. Tried my best to search of the topic, but no luck: I am trying to replace a # character and all characters after in a text field. U set up a Select query and used the following expression: Expr1: Replace([Part Number],"[#]*","") It doesn't change any of the records. Is this...

I'm new to this forum . I've been working with Access for years but I'm much more of a muddler than a hard core user and really not a programmer. Being an old guy I've been pretty leary of making the jump to full SQL code and have been trying to limp through with the GUI. I've come here...