Two report questions:
1) Regarding filters. I've created a physician orders query that pulls the data I need from several different tables. I need to create a filter that looks something like this:
DatePart("yyyy", date1)="2001" AND DatePart("m", date1)="11" DatePart("d", date1)="04"
OR
DatePart("yyyy", date2)="2001" AND DatePart("m", date2)="11" DatePart("d", date2)="04"
OR
DatePart("yyyy", date3)="2001" AND DatePart("m", date3)="11" DatePart("d", date3)="04"
For the life of me, I can't figure out where I should use this filter and how to design it. Ultimately I need to produce a report based on this filter but the user will be able to specify the date. Also the dates are a date/time field. Aside from using three DatePart commands, is there an easier way to extract just the date and note the time. They are both in the same variable.
2) From the above query I will be producing a report. My dilemma is as follows. I want to summarized a list of medications followed by a list of procedures, followed by a list of xrays. However, not all infants will have the same number of each but I still want my form to be continuous. IE: if the infant only had one medication, the next line should begin procedures. If they had 10 medications, the following would still be procedures but without out any big space gaps. Does this make sense? It wasn't clear to me by using the report design that this was possible.
In the database there are variables med1, med2, med3, med4, med5 etc.. followed by lab1, lab2, lab3, lab4 etc..
Thanks for any help you could provide.. I'm hoping I'm missing something easy.. I can provide more information if required.
Thanks, Shawn
1) Regarding filters. I've created a physician orders query that pulls the data I need from several different tables. I need to create a filter that looks something like this:
DatePart("yyyy", date1)="2001" AND DatePart("m", date1)="11" DatePart("d", date1)="04"
OR
DatePart("yyyy", date2)="2001" AND DatePart("m", date2)="11" DatePart("d", date2)="04"
OR
DatePart("yyyy", date3)="2001" AND DatePart("m", date3)="11" DatePart("d", date3)="04"
For the life of me, I can't figure out where I should use this filter and how to design it. Ultimately I need to produce a report based on this filter but the user will be able to specify the date. Also the dates are a date/time field. Aside from using three DatePart commands, is there an easier way to extract just the date and note the time. They are both in the same variable.
2) From the above query I will be producing a report. My dilemma is as follows. I want to summarized a list of medications followed by a list of procedures, followed by a list of xrays. However, not all infants will have the same number of each but I still want my form to be continuous. IE: if the infant only had one medication, the next line should begin procedures. If they had 10 medications, the following would still be procedures but without out any big space gaps. Does this make sense? It wasn't clear to me by using the report design that this was possible.
In the database there are variables med1, med2, med3, med4, med5 etc.. followed by lab1, lab2, lab3, lab4 etc..
Thanks for any help you could provide.. I'm hoping I'm missing something easy.. I can provide more information if required.
Thanks, Shawn
