Recent content by Klo

Hi John, You may be right in that Duane's solution might be easier if I can get it to work but I started down this path (your code) and I really want to understand it. I'm never going to learn this stuff if I quit when it gets tough. I've already learned a great deal in the little I've...

I don't know. Sometimes there are fewer than 5 test dates. Also to be honest, I don't know how to set up a multi column report (yet).

Hi Duane, The dates I need are the last 5 test dates, so there is no set interval. The dates could be seperated by days or months and the person running the report has no way of knowing what the dates are. If it were easy I could figure it out myself and not have to pick the brains of the...

Ok ... I'm confused on a much higher level now John. Here's what I have so far that works: mySQL1 = "TRANSFORM First(Query7.Results) AS FirstOfResults " mySQL1 = mySQL1 & "SELECT Query7.Test_full_name " mySQL1 = mySQL1 & "FROM Query7 " mySQL1 = mySQL1 & "GROUP BY...

Thanks guys. I hope to get a change to work on it today or tomorrow. I'll let you know how it goes (or dosen't). Thanks again.

I have a report based on a crosstab query. The report displays fine until the data from the crosstab query changes. The query places the column headings as dates and when the dates change the report gives a error saying that it dosen't recongize 2/6/06 ( or whatever it happens to be)as a valid...

Thanks again Duane. I think I'm getting the hang of it. I couldn't have done it without your help. Cheers

Also where are the color properties set? I can't seem to find them ... I think I understand less than I understood.

Beautiful! I think I am begining to understand how you are using the subreports. One last thing ... the colors are based on ranges not a single value. Could tbltargets have a high and low or maybe a high,normal,low?

I think the cartesian query might work for what I want. Now if I create a table for say Calcium with column headings of High,and Low and a row of 10.5 and 8.9. I want any value for Calcium >= 10.5 to show up as red and anything <= 8.9 to show up as blue. Is this set on the report?

Thanks so much Duane! I'm not sure I understand how you did it. I have never used a subreport before. I will do some reading today on the subject. A couple more quick questions if you have the time ... Is it possible to have the name of the test only appear in the first column? Also is it...

Is there an example of that I could look at?

The query will return data like this: Date Patient ID Test_full_name Concentration Units 6/15/2004 9995.1 T. Billirubin 0.54 mg/dL 6/15/2004 9995.1 Creatinine 1.05 mg/dL 6/15/2004 9995.1 Albumin 4.12 g/dL 6/15/2004 9995.1 Potassium 4.32 mmol/L 6/15/2004 9995.1 Total Protein 6.90 g/dL...

My boss has decided he want to change our lab reports to show the last 5 series of tests. There are about 10 tests per date. I know I can run a query that orders the tests by date. My questions are: 1. How do I populate the report in columns by date? 2. What if there is less than 5 test series...

Thanks guys, all the info helped. I finally got it to work. Thanks again.