Recent content by coolkake

That has got it guys!!!! Thanks a lot :) This is great because I've got an example now of how to do this and there's a whole bunch more things I can do now :)

Sorry about that. Yes the numbers are always 5 characters long and there is always a space before and after a number. All I want back is CLIENTELE CALL #####

I had to edit some of the information but not the structure. The lines (-----) at the top are included in every field but not always at the very top like this one shows. It does look like after the ----- it does have CLIENTELE CALL on the next line though...

Didn't change anything in the results :( Here's my SQL now SELECT RMA_Emails.Contents, Right([Contents],Len([Contents])-InStrRev([Contents]," ",-1)) AS NewField FROM RMA_Emails WHERE Contents LIKE "*CLIENTELE CALL*";

Leslie This works but the results have nothing to do with CLIENTELE CALL in the memo feild. Is there a way I can search for that and report back "CLIENTELE CALL ?????" with the ? being the number of each call?

I totally understand your thoughts Harley and I don't want someone to make me the solution; that's what consutants are for :) I want to figure out this one particular problem and using what I've learned from this I will be able to address some others as well. Having said that I think I need a...

I've read over the help files on INSTRREV and I'm just not getting it. There are no examples of what this does :( Feeling stupid this Monday morning :)

Thanks but I don't have any experiance at all in the module/code window of access. When I've gone there in the past I have never gotten anything to work :( Is there anyway to do this using SQL statement or from design view in Access? Also if you know of a good online course for VBA for Access...

Hey all I've got to figure out a way to query a memo field to only show me the numbers after CLIENTELE CALL in the memo field It would look like this in the field CLIENTELE CALL 12345 When I try a query looking for CLIENTELE CALL it returns everything in the memo field and I can't figure out...

Is there nothing I can put in the fomula to ignore blank cells? =if(B1=C1,1,0) gives me what I'm looking for but then when I paste this down the colum it adds a 1 to all the blank fields. SkipVought, don't really want to use the AutoFilter for this particular sheet. Thanks though.

Is there a way to have this ignore null values? This works great but when I try do paste is for the entire colum all the empty spaces show up with 1 because they match.

Hi I've looked for a way to do this but I can't seem to find what I'm looking for so here's my issue I want to count all the location where colum B equals what is in colum C in the spread sheet. Below is an example and there are blank fields in between each of these entries; sometimes just...

No because I need to make an index page that will allow a user to click on a link to view a particular customer. Unless I can edit a PDF to do that, I'll give it a try but the only thing wrong is its not exporting the line so there is a break between each entry. Thanks

Hey All I've got this report done in Access 2003 that shows everything required and looks quite nice. When I save it as a html page none of the lines or colors are in the html doc, just the text. Is there a work around for this? Thanks in Advance :)

Thank You, Thank You, Thank You God do I love this site ;)