Recent content by Echo_3

Thanks, that was it!

I want to change: 203 to 2 1202 to 12 In other words, I want to drop the right two characters. Any ideas?

I have created a pass through query that works as a SELECT query. I want a to create a table using this same query but it won't let me. Any suggestions why?

I'm not getting it and I know it must be simple. I have two tables Table1.................Table2 ....109......................109 11871....................1321 20575..................71656 27800..................20575 ............................27800 I want to delete from Table2 all the...

I really need this driver and don't know how to get it -- any ideas? IBM AS/400 Client Access Express V4F4M0 Thanks.

THANK YOU!!!!!! It works!!!!!!!! Perfect. This is the best site to get answers for my Access questions!!

I needd to concatenate two fields. Why isn't this working? SELECT Concatenate([Beach Contracts with Name].[Contract#],[Beach Contracts with Name].[Add-On]) AS ContractGuide FROM [Beach Contracts with Name];