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

    Replace, Strip or Remove Text from a field

    pmax9999 your suggestion worked perfectly! THANKS!
  2. product26

    Replace, Strip or Remove Text from a field

    Hello, We have a field in our database which contains a formatted paragraph of text for each entry. I need to remove the formatting code from the field and list only the text. I have a list of all of the possible code to be removed, but I cannot get crystal to actually remove it. I tried the...
  3. product26

    Transferred Calls Not Logged Avaya IP500 5420

    We have an issue where a call that is transferred is only being logged as the extension it is forwarded from. For example, a call is answered by extension 100 and transferred to extension 301, the call log on 301 only shows that the transferred call was from 'ext 100' and not from the original...
  4. product26

    Counting Duplicate Entries

    Thank you much! that did the trick!
  5. product26

    Counting Duplicate Entries

    I was in a bit of a rush when i typed the original post. What I have is a table called 'orders' in this table we have entries that are all given unique 'Order IDs'. Each entry in this table is a classified advertisement, in order for an ad to be placed in more than one classification, or...
  6. product26

    Counting Duplicate Entries

    I am building a report for a company that works in classified ads. The ads are stored in their own table, & I need to count the number of ads that are in more than one classification. I was thinking that I could count any ads that have matching ad text fields & different 'orderid' fields. The...
  7. product26

    System Incompatibility on 5621SW IP

    http://www.tek-tips.com/viewthread.cfm?qid=1459830&page=7 In the above thread, kholladay suggests that "With 4.0 you have no way to license the VPN phone so it will (should) stop working after the 180 days trial has expired. " Looks like our IP500 is running 4.0(10) If we upgrade to the last...
  8. product26

    System Incompatibility on 5621SW IP

    one post suggested that the original firmware may expire after a certain number of days...?
  9. product26

    System Incompatibility on 5621SW IP

    We have 4 5621SW IP phones running i20aVPN23249.bin firmware. The phone connects to the VPN just fine and appears to boot just fine, but as soon as the phone displays its normal screen for a millisecond, and appears as if it is going to log in the extension, it goes blank and reads "system...
  10. product26

    Excluding first word in a field.

    PERFECT! Thank you!
  11. product26

    Excluding first word in a field.

    I need to exclude the first word in a field. Our database does not have individual fields for first and last name, we simply have "{customer.custname}". (this is because we service businesses as well as individuals, but we need to be able to search for them from the same field) I have...
  12. product26

    Cisco SDM losing connection.

    Whenever I try to make a change using Cisco SDM it gets to the "command Delivery status" window and doesnt get past preparing commands for delivery, and then loses connection, every time no matter what I am trying to modify. I have tried both IE and Firefox with no luck. Anybody have any...
  13. product26

    Cisco 2651xm - Worth Keeping?

    Cisco Internetwork Operating System Software IOS (tm) C2600 Software (C2600-IPVOICE-M), Version 12.3(22), RELEASE SOFTWARE (f c2) Technical Support: http://www.cisco.com/techsupport Copyright (c) 1986-2007 by cisco Systems, Inc. Compiled Wed 24-Jan-07 16:48 by ccai Image text-base: 0x80008098...
  14. product26

    Cisco 2651xm - Worth Keeping?

    We recently switched phone carriers and now have a spare Cisco 2651xm router at our disposal. I am unsure weather or not we should plan on selling the router or if I should keep it around and make use of it. I am hoping that if I list our basic networking needs, someone may be able to tell me...
  15. product26

    Comparing Unlike Fields

    I think you have helped me get on the right track. Thank you much!
  16. product26

    Comparing Unlike Fields

    if {orders.orderid} = {orders.external} this is considered New if {orders.orderid} <> {orders.external} this is a rerun. i need to show only new in one summary and only reruns in another. so for a rerun i need to show every result where orders.orderid (12345) is greater or less than...
  17. product26

    Comparing Unlike Fields

    sorry, for some reason it cut off my post... I keep getting errors about tgml code... i don't understand. The forum is probably not compatible with Safari 3. orders.orderid contains all numbers orders.external contains the same numbers as orders.orderid only with "TN" as the first two...
  18. product26

    Comparing Unlike Fields

    I have a situation where I need to do a Comparison on two fields that are not alike. One is a number field, and one has mixed text and numbers. when i use: {orders.orderid} <> {orders.external}
  19. product26

    Counting Items Entered on each Day of the Week

    Only problem with what I last posted is that on the weeks that span over the end of one month and the first of the next, the values are reversed (The number of items entered on wednesdays are swapped). for example: 12 items were entered on Wednesday October 24th that are to be delivered on...
  20. product26

    Counting Items Entered on each Day of the Week

    perhaps if {orders.dtentered}=DateSerial(Year({?StartDate}), Month({?Startdate}), 1 - 1) and dayofweek({orders.dtentered}) = 4 then 1

Part and Inventory Search

Back
Top