Reply to thread

Message: [QUOTE="myoda, post: 2544307"] I have a table with some data in it already, in one column I need to locate all dollar amounts of more than $0.00 and place an M there instead, and replace everything that is $0.00 with nothing - is there any way to do this. Also I have another column with numbers like 24B, 24H, 24F, 24C, and so on, what I need to do is get rid of the first two numbers and leave just the letter in the column - is there any way to do this without going through each cell and erasing the number. I'm using access 2000 Thanks [/QUOTE]