Recent content by cousinconley

Agreed. I have proceeded with disposal. Thanks.

I have an old Best Fortress UPS. When I plug the unit into the electical outlet, the digital display and sensor lights blink repeatedly for roughly 30 seconds then it shuts off. There is nothing legible on the display. It starts with all 0's then every pixel illuminates. I left it plugged in...

Thanks bborissov, yours looks more strait forward than mine.

My appologies..after I posted this message it came to me: SELECT A.* FROM PS_JOB A WHERE A.EMPLID = '123' AND A.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_JOB B WHERE B.EMPLID = A.EMPLID AND B.EFFDT <> (SELECT MAX(C.EFFDT) FROM PS_JOB C WHERE C.EMPLID = A.EMPLID))

Heres the scenario...I have a table with effective dated records. This means employee 123 can have multiple records all identified by a date. Example: employee 123 gets a pay raise on 01-29-2006. Employee 123 then gets another raise 08-30-2006. Later employee 123 gets yet another raise...

Thanks, I will try using that.

Unfortuneately in this situation, moving or resizing itsn't an option due to users' requirements.

I have detail data that I have drawn a box around. I have set my watermark on Page Header B with "Underlay Following Sections" checked in Page Header B. I made sure the graphics are set to background not forground. When I run my report the watermark functions correctly except for the lines...

Thanks lbass. Both sound like good ideas. I did not think of it before. That has given me some ideas. Thanks again. Richard

Sorry that is about as descriptive as I can get it.

Ok, I have a record. Each record has 8 attributes that are either true or false. A record can have multiple attributes that are true. So, how do I group by the true attributes and have a record print multiple times...once under each attribute grouping? This is what I have so far: SELECT 'Y'...

Got it figured out: numbervar firstday:= 01; numbervar firstmonth:= 01; numbervar currentyear:= year(CurrentDate); datevar begofyear:= CDate(currentyear,firstmonth,firstday); numbervar Age:= DateDiff("YYYY",{PS_PERSON.BIRTHDATE} , begofyear);

I am trying to figure out how to do a datediff calculation using a persons birthdate and first day of the year. I do not want to hardcode 01/01/2006. If I hardcoded I would have to update the report formula every year. This is what I have so far: numbervar Age:=...

Thanks Tom, that did it. Richard

I am creating a document in MS Word 2000. I would like the page numbering to begin with 1 on the 4th page. The pages prior to the 4th page are just front matter. I would like the front matter to be numbered using Roman numerals. So the 1st thru 3rd pages would be I, II, III and the 4th page...