Recent content by 5lights

I may look into making my own MS SQL db & importing the data to more appropriate tables.... any suggestions? I'm thinking just pulling Answer & RespondentID where QuestionId=1 to a seperate "Employee" table should do the trick

Its a MS Access db. Yes, I agree completely....lousy db design. But, it is the survey scanning output I have to deal with. Question 1 is Who... & the answer 'Bob' is the 'Person' I want to summarize Yes, RESP is the RESPONDENT ID. So Bob's summary has to cover Questions 2-10 for every...

CRv11 I want a Crosstab for each Person Identified in a survey giving a summary of how they were evaluated on 10 questions. This should be easy but.... The 'Person' is identified by a multiple select in Question1. The table looks like this: RESPONSES(Question, Answer, Respondent)...

CRv11 Table A(ie Sked) has DATE, TIME, NAME, POSITION, etc Table B(ie Clock)has DATE, TIME, NAME, etc FROM "SKED" LEFT OUTER JOIN "CLOCK" ON ("SKED"."DATE"="CLOCK"."DATE") AND ("SKED"."NAME"="CLOCK"."NAME") Now I want to evaluate person for "OnTime", "Late", or "Not ClockedIn" I can tell...

I have two tables linked appropriately to return all records from the Primary(Table A)& just matching from Secondary(Table B). I gives me exactly the records I need. But, now I need to evaluate based on the field(singular) that I am pulling from Table B. since its niether NULL nor valued, I...

BINGO. Thats pretty good, you all came up with the same(relatively) answer....and it works. I'm now getting 200603300815 for 2006-03-30 08:15:32. Thanks

How do I convert a DateTime to an Unseperated string? 2006-03-30 07:00:05 to 200603300700(yyyymmddhhmm) I got a DateTime to 20060330 by Convert(nchar(8),table.field,112) but now I need to include the time.

Worked like a charm. I had to modify some for my data peculiarities (ie startdatetime only has time, date is 1800,01,01) so my solution was: whileprintingrecords; shared numbervar RmTO; if {table.CASE_NO} = {?Pm-table.CASE_NO} then if onfirstrecord then RmTO := 0 else RmTO :=...

WhooooYaaaa! (Thats Okey' for "Now you're talking") Looks good. I'll let you know how it turns out.

Then I'll just get the one record & unable to use the PREVIOUS function. I need the same room, but two sequential cases to do the computation.

Using CR8.5 Main report shows OR Case info sorted by StartDateTime for all ORs in a given daterange. I need to compute Room turnover time. Tried a SubRpt linked by date & room and was able to compute Turnover's with a Start-Previous(End) formula. But could not pass it to the MainRpt tied to the...

Disregard...I made it LEFT Outer Join....I'm on a roll now. Thanks[smile]

Doi'[surprise] OK now its saying "Incorrect syntax near the keyword 'outer'.".....why does it argue with me? I guess I'm just_________( I'll fill it in for you)new to SQL.

I'm trying to adapt code from thread183-1089209 but dont seem to be getting it. Basically, I'm trying to show multiple shift assignments on a single row. I have two tables: NURS with the ID STAFF with the SHIFT Assignments My adaptation is dorked: SELECT N.ANSOS_ID,N.NURS_NAME...

I just finished re-writing it in CR8.5. I got the responses I expected....was just hoping for some little known shortcut. Next project: to write a purchase request for 'BO XI' so I can distribute reports without the version limits within the host applications.