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...

When I do that, it only gives me the option to select the fields from the master table1. I can't get into "sorting and grouping" when I highlight subreport table 2.

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...

Thanks for the reply, I redid the whole report again. Yes, I'm using subreports from the subreports within a form. It's a clean insertion without any other lines or buttons. The first record looks exactly how I want it. It spills over nicely to the 2nd page. But the 2nd record is still...

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...

Again. Thanks for your help but I still can't get it to run correctly. Would you mind if I send you my Access file so you can see what I'm doing? Email me at cfan@dhs.co.la.ca.us

I should add that some of the numbers are zeros or the field could be blank from 1stPOS-4thPOS.

Thanks for the suggestion. I tried as you said but I get the following error 2E+12

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...

Thanks for the help. If I may bother once more. Let me clarify a bit. The comments are not exactly the last thing on the 1st page so the spill over would be easy. There's actually a couple of more fields underneath comments. So I would like to keep the size of the comments box fixed, any...

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.