Search results for query: *

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 ;)

Hey All I've got a simple countif and all I want to do is change the cell color on the items that fall into this criteria. For some reason I can't figure out how to make this happen ;( Here's my countif =COUNTIF(I:I,"<=29") Thanks in advance Kake

I found a fix, you need to re-install MSOWC.MSI from the Office 2000 cd and everything works fine after that. Not sure why Office 2003 isn't backwards compatable especially since this was an upgrade and not a fresh install but who cares now, it's working again ;) Cheers Kake

Hi I created a data page using Access 2000 quite some time ago and now that our office is converting to Office 2003 users that have been upgraded can no longer use my data page. Is there anything I can download to fix this or do I need to convert the database and datapage to 2003?

You are the MAN!! This is Awesome, I'll have to play with it to see what does what but it worked like a charm for what I'm doing right now. Thank you so much ;) Ken

Column A is the Location field in Site Column A is the Location field in Version I tried this formula =HYPERLINK("#"&SUBSTITUTE(CELL("address",Version!$D$9999),"9999",MATCH(A2,Version!D:D,0)),A2) I highlighted all of Column A in Site and did an Hyperlink Insert and choose "Place in this...