Search results for query: *

I just need to fix this one irritating problem and I'm done. I have a report about Patients. For each Patient, there is a subreport about the drugs they take, and another subreport(in the Footer because we want this to appear on every page) about the Labs for each patient. I can't get the...

1st table is Patient with; Pat#,name,healthcenter,DOB 2nd table is Treatment with; Pat#,DateTreat,drug1,drug2 3rd table is Laboratory with; Pat#,DateLab,Labname,Labtest Tables 2 and 3 are linked to table 1 by Pat#. One to many relationship. I want my Report to look like this: HEADER: The...

Each record in my table has a date in the date field. I sorted the date field in ascending order but in my Report it doesn't seem to get reflected. The table is linked as a subreport in the Report itself, which in turn is also a Child linked to a Master table in the Report. To simply: 1st...

I have 2 subreports in my Report. There is enough data to spill over to the second page. However when I print preview, the second page just prints the heading for the subreports, not the data. Also the next record is blank with only the headings. It's like it only wants to print the first...

I am given the assignment to make a Report look a certain way. The look is fixed. I have a header a repeats and I have 3 subreports whose size are fixed. They don't grow. However, the records will go beyond the border so I want them to continue to spill over to the next page. Hope someone...

Hello, I create a simple lookup value for 12 different drugs that are layed out across the form page. Without the lookup which puts in a drop-down arrow to the right of the cell, everything fit nicely on 1 page. But with the lookup, each cell got wider because of the lookup arrow. How can I...

Hi, I have a Access database with 2 date fields, Date Sent and Date received. How would I go about querying the difference between Date Sent and Date Received without counting Weekends because business is closed during weekends? e.g difference between 1/3/03 and 1/13/03 is 7 days. Also...

Suppose I have the following table where Type,1stPOS,2ndPOS,3rdPOS,4thPOS are the fields: Type 1stPOS 2ndPOS 3rdPOS 4thPOS Red 1 1 1 1 Blue 2 2 2 2 Blue 2 2 2 2 And I'm...

I have a big Comments field at the end of the 1st page of my Report Form. If a user's comments get too big, how do I make it spill over and generate a 2nd page? Thanks.