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: *

  • Users: AyJayEL
  • Content: Threads
  • Order by date
  1. AyJayEL

    Use SQL to add ZZZ to surname

    I have a table called Student. Two fields called NCY (number) and surname (char). I want to add ZZZ to the start of the field Surname when the NCY = 99. So the field STUDENT.Surname = Bloggs will become ZZZBloggs if he has NCY = 99. Can you help me with the commands for this? I have an...
  2. AyJayEL

    Saving Greyscales

    Ok I know that just converting to greyscale is the lazy way and doesn't give the best results but I just wanted to convert a number of files and do some experimental work on a collage. But I've found that PSP won't save the file once I've converted it. I'm saving as JPEG. I don't have problems...
  3. AyJayEL

    RAW Support

    Just to let everyone know who owns a camera that PSP X1 now supports the following(Update 11.2):- Canon EOS-1D Mark II, 5D, 10D, 20D, Rebel, Rebel XT, Rebel Xti, 400D, 300D, 350D, Kiss, Kiss n, Kiss Digital X, D30, D60 PowerShot G3, S30, S40, S50, S60, Pro1 Fuji FinePix F700, S5000Z, S7000Z...
  4. AyJayEL

    Highest Number

    How can I find the top two values for a range of numbers. i.e. I have a count for children based on their National Curriculum Year (NCY). I want to know now which two NCY's have the most children in them. Learn something new every day Using Crystal 8, Oracle Database Paint Shop Pro X1 Nikon D80
  5. AyJayEL

    Grouped Mail Merge

    I have a data source like this. Name Base Email Course Date Fred Home b@C Learn 3/6/07 Fred Home b@C Get etc 4/5/06 Jenny House j@D Learn 3/6/07 Jenny House j@d Yes do 5/4/06 Jenny House j@d People 7/8/06 Peter School d@f Learn 3/6/07 Peter School d @f Get etc 4/5/06 I want to...
  6. AyJayEL

    What stops records returning?

    I have a report with lots of tables in it. Every table is linked using an outer link. Yet, when I run it if a person doesn't have an address logged in the database it won't bring them back in the report. What else could stop the record being returned in the database apart from the table linking...
  7. AyJayEL

    How do I write the SQL expression for memo field

    I need to use a memo field in a formula. Reading through the other queries here I have worked out that I need to create an SQL expression. This is what I have (substr(MEMO_STR_Choices.MEMO_DATA,1,250)) but when I try to save it I get a message saying invalid identifier. I think this is possibly...
  8. AyJayEL

    Print File Name on Photo Automatically

    I have some photos that I want to use as proofs and I would like to be able to print the file name on each photo automatically. Does anyone know how you do this in Paint Shop Pro (XI) Learn something new every day Using Crystal 8, Oracle Database
  9. AyJayEL

    PSP XI now available for download

    I see that PSP XI is now avaialable for download. Has anyone done it yet? Anyone tried it? Learn something new every day Using Crystal 8, Oracle Database
  10. AyJayEL

    Grand Total from Subreport

    I have a report with a Student Group 1, CaseWorker Group 2. I am suppressing the whole Student Group when there is only one CaseWorker and where the CaseWorker is not in Service 2. I the group footer details B for the Student I have a subreport that brings shows all the time spent working with...
  11. AyJayEL

    First record won't suppress

    I am using Crystal 8 with an Oracle database. I have a labels report that if a boolean is true then it should display an email instead of an address. The address is in section A and the email is in section B. It works fine exect for the first record when it displays both the email and the...
  12. AyJayEL

    No Future Dates

    I need to find out people whose term of service is ending within a range parameter of dates who don't have a future service set up. They may have several or only one previous service. I am using Oracle and Crystal 8. for example I don't want to see the following ID Fred Bloggs Start date...
  13. AyJayEL

    Ignoring first record in summary

    I have a report based on an oracle database. It has 3 groups. Group 1 Name. Group 2 Type. Group 3 Base. I am adding up time in the details. I have to suppress duplicate records using field = previous(field) in the section details and also in the summary fields on the data. My problem is that the...
  14. AyJayEL

    Tablet PCs and PSP

    Does anyone use a tablet PC with PSP? How does it handle it? Would you recommend one? I quite fancy being able to edit directly onscreen, 1 to 1 so to speak. Learn something new every day *:->* AyJayEl
  15. AyJayEL

    Count only the latest record

    I need to count only the most recent records for a person where the FSM field is True. I don't want to count the record if it's true if there is a more recent record that is false. I'm sure it's simple but I'm struggling! Person id Date FSM 1 1/1/2005 T 1...
  16. AyJayEL

    Why doesn't this formula work as I expect?

    I'm trying to write a formula to show the number of days either between a start date and an end date or where the end date is blank, to use today's date. It will only show where there is an end date and shows blank where there is no end date. Can anyone tell me what I'm doing wrong? See below...
  17. AyJayEL

    PSP X

    So what do you like best about PSP X? Personally I love the new 'makeup' tools. I have managed to fix my lovely but slightly spotty daughter's photo so that she looks gorgeous! It would be mean to keep a photo of her with a less than perfect skin when I know she's going to grow out of it! Learn...
  18. AyJayEL

    Checking a range of dates

    I want to check if a Date of birth is within a date range. DOB Start End Result 1/7/1994 1/9/1993 31/8/1994 False 15/10/19931/9/1993 31/8/1994 True etc What formula would I use in Result column. I've tried if but I don't know how to specify A2 is between B2 and...
  19. AyJayEL

    Combining Emails

    Has anyone had the following happen? Sometimes my emails are combined together. For instance yesterday I had a notification email from a website forum I am a member of and one from Genes Connected merged together into one email. Yesterday there was also an email with nothing whatsoever in it...
  20. AyJayEL

    Dubious Rhymes

    How about this for a dubious rhyme? Pulp's 'Dishes';- I am not Jesus Though I have the same initials I am the man who stays home and does the dishes. Know any more? Learn something new every day *:->* AyJayEl

Part and Inventory Search

Back
Top