Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. coolkake

    Query memo field to only show

    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 :)
  2. coolkake

    Query memo field to only show

    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 #####
  3. coolkake

    Query memo field to only show

    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...
  4. coolkake

    Query memo field to only show

    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*";
  5. coolkake

    Query memo field to only show

    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?
  6. coolkake

    Query memo field to only show

    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...
  7. coolkake

    Query memo field to only show

    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 :)
  8. coolkake

    Query memo field to only show

    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...
  9. coolkake

    Query memo field to only show

    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...
  10. coolkake

    Excel - Count if two cells are equal

    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.
  11. coolkake

    Excel - Count if two cells are equal

    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.
  12. coolkake

    Excel - Count if two cells are equal

    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...
  13. coolkake

    Export Report as web page

    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
  14. coolkake

    Export Report as web page

    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 :)
  15. coolkake

    Countif - want to change color of cells that meet criteria

    Thank You, Thank You, Thank You God do I love this site ;)
  16. coolkake

    Countif - want to change color of cells that meet criteria

    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
  17. coolkake

    Data Page - Access 2000 and 2003

    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
  18. coolkake

    Data Page - Access 2000 and 2003

    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?
  19. coolkake

    Linking between one worksheet to another

    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
  20. coolkake

    Linking between one worksheet to another

    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...

Part and Inventory Search

Back
Top