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

    Remove blank character

    I have Crystal 8.5 using SQL 7.0. The first field in the formula will either be " 123456" or "123456" and the second field is always "123456". Can I do the trim function on an "if first character is blank space" then trim it? Thanks.
  2. lawre016

    Remove blank character

    Hi, I have a text field that may or may not start with a blank character. I am trying to select records where {SHOP_ORDERS.LABEL NAME ITEM} = {Labels.Name}, but if the first field has this blank in the front, it will not match with a record from the second table (no blanks in the second table)...
  3. lawre016

    Date Function

    Perfect - Report is done. Thanks to all!
  4. lawre016

    Date Function

    Thanks, I created a SQL expression %Date using convert(datetime, substring(PR_DC_ND_TRG_LST.PR_SIGNOFF_DT_TRNEE,1,11)) which returns a correct Date format 05/01/2003. Now what I need to do is be able to create a parameter in the report to choose specific date ranges such as 05/01/2003 thru...
  5. lawre016

    Date Function

    I have a field in a SQL table that displays 05-Sep-2002 16:00:31 (it's a char field). I need to convert it into the following format yyymmdd so that I can use a date range parameter in my report. (I do not need the time) Can anyone help? Thanks!
  6. lawre016

    Datediff error

    DH_DOCUMENT.DH_ISSUED_DATE is a string field. I am converting that to a number (ToNumber), then converting that to a date.
  7. lawre016

    Datediff error

    What am I missing? This formula Datediff("d",({@Routed Date}),NumberToDate(ToNumber({DH_DOCUMENT.DH_ISSUED_DATE}))) + 1 Gives me this error: "A number, currency amount, date - time string expected here". It is just before the 'NumberToDate' FYI @routed date = Date...
  8. lawre016

    DTS Fails

    I have 2 SQL 7.0 Servers, I am trying to copy a DB from one to the other using DTS Export Wizard, I choice the 'Transfer Objects and Data...' option so I get all the stored procedures etc... During the transfer I receive an error "Login already has an account under a different user...
  9. lawre016

    Close window with batch file

    I couldn't find a way to close it either, but I thought I'd ask just in case I too was missing something. I would really appreciate if you could show me the correct way to install fonts using the login script. Thanks.
  10. lawre016

    Close window with batch file

    Nope, no registry entries. Since it works fine after I open the fonts folder, I figured it was ok. Actually, I need to close the C:\WINNT\Fonts window that the batch opened, not the cmd window the batch is running from. I just don't want users to call because that window is open on their...
  11. lawre016

    Close window with batch file

    We recently installed a new font to every machine using the login script. For some reason the font will not show up on forms unless it is "initialized" first - I did this by just opening the Fonts folder and all was well. My problem is that I don't want to go to every machine and...
  12. lawre016

    Return one of many

    Thank you. That worked great.
  13. lawre016

    Return one of many

    I have 2 SQL tables linked by the document number. The first table has multiple entries for each document, the second table has only one entry. I need to only show the first record from table one, not each entry. The results currently look like this: 14-1-001355 02 RETAINER 14-1-001355...

Part and Inventory Search

Back
Top