Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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