Recent content by mkrinke

Not my table, I just have to deal with adding data to it.

I have a table with 3 fields, fld1, fld2 and fld3. If any of the fields has a value, I want to copy that value into all 3 fields. Even if 2 or more fields has a different value, I want to take any one of the values and populate all 3. Any suggestions on a good way to do this?

When you put it that way it makes perfect sense... I wish I had looked out here earlier - before I spent alot of time trying to get it to work the way I thought it should. It's always the little things that hang me up. Thanks for the help !!!

I think that the compress function is what you're looking for. I have also had problems with the dequote function - I can't get it to work. If I input and try to remove quotes from this stmt: This is a "test" input stmt $20. ; x=dequote(stmt) ; --> the quotes don't go away...

Also worked. Thanks !

thank you!!! (this site is damn helpful!) Mark

I was just working on a macro to multiply by one... but I'm curious about the other option: For each c in selection c.value = c.value*1 next c Where do you put this code to run it everytime the query is refreshed? Thanks, Mark

I have the same problem, but the field is in a worksheet created by a query. Everytime I refresh the query the fix is gone... Any ideas on fixing in code or some other trick? Thanks, Mark - new at this Excel stuff