Search results

I have attached the updated DB with the command button to open the report. Also added the other text box. Here is the flow of things as requested starting witht he form. The top form header uses tblCommitteeInfoEntry. Each of the subforms uses RDStudyAuditSectionA which are in 6 parts up to...

Here is the error I am getting: This expression is typed incorrectly, or it is to complex to evaluate. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables. I have the two boxes and they...

What should the source record on the frmpopup be? Do I keep the Text boxes unbound? I entered the text as you suggested but comes up with a complex error. I have atached the DB so you can see what I have done thus far.

I created the popup form and named it frmpopup. I placed two text boxes there but my question is should they be unbound? If they are to be named, what name should they be called? Right now there Text4 and Text5. Also what should the record source be? The query I am using for the totals is...

I tried everything you asked but I may have done it wrong. This is very frustrating when I do get most of what your saying but what I don't makes me cringe. I attached part of my database so you can look at it and see what I am doing wrong if you don't mind looking at it. Thanks for your help...

I got part of it to work but I have to enter the dates 3 times each for start and end date. In the query that pulls for the report I entered this: Field Start Date: [Audit Date] Criteria [Enter Start Date Like: 01/01/10] Field EndDate: [Audit Date] Criteria [Enter End Date...

I understand now partially what you were saying. The pop up form is my sub-report that has the totals. I am still confussed on how to fill the code in the query. This is what I have so far: Between [frmRDStudyAudit]![NameOfPopupForm]![Audit Date] And...

I enter the date of the audit in the form. In the query for the report I use this code: Between [Enter Start Date Like: 01/01/09] And [Enter End Date Like: 12/31/09] As the report opens I put in the date range I want. I need the count to reflect the totals from that range.

I have a query that is used to pull data to the report by between dates to include writeups and yes, no, and N/A's per question (combobox). Works great. I created another query to pull the totals of yes, No, and N/A's by column off of that query. Here is one example of one of the questions...

I have attached part of the DB so you understand what I am trying to do. If you look at the column in the middle that is what I am trying to count for each Yes, No and N/A. I like to be able to do a percentage of the Yes + N/A - No if that is possible. The "Yes" and "N/A" would total 100% -...

I have a report where I am trying to count all the text boxes which comprises of about 8o. I want to separate them by Yes, No and N/A. I tried a few different options and none have worked in Control Source. Example1: =Count(IIf([RDStudyAuditSectionA.Doc #12-5]+[RDStudyAuditSectionA.Email...

I tried this formula in the report and recieved (Com-Doc #2) 0 and (Com-Doc # 37) -1. However, it did collapes the text box blanks. I just probably need it fine tuned to get the text to show versus numbers. =[Com-Doc #2] & " " & [Com-Doc #25] & " " & [Com-Doc # 37]=[Com-Doc #2] & (" "+[Com-Doc...

I have a report that I can not collapes the blanks cells. I have "Can Shrink" and "Can Grow" both set to Yes. The problem is that if there is data in one of the cells, the rest of text boxes even though empty, the section grows. I have the section set to pull by Principal investigator. If you...

Tried exactly what you said and I get the exact results. I broke it down to just 5 columns to see if it worked but it dsidn't. Is it possible in the query to not show the blanks when you have a lot of columns? I don't think it is possible but worth asking.

I have a report that I can not collapes the blanks. I have "Can Shrink" and "Can Grow" both set to Yes. The problem is that if there is data in one of the cells, the rest of text boxes even though empty, the section grows. I have the section set by Principal investigator. If you look at the...

I have attached part of the db so you see what i am trying to do. Thanks!

I was thinking of a way to work it into the report to show only what I need. I removed the distinctrow and tried distinct and just select and still pulls all data incuding the blanks. Also removed Group By but it didn't like that. I've had some hard one's in the past but I don't think this...

Here what I did and still not getting what I need. I only want to see if (Com-Doc #2) has data. SQL View: SELECT DISTINCTROW tblCommitteeInfoEntry.PI, RDStudyAuditSectionA.[Audit Date], RDStudyAuditSectionA.[doc #2], IIf(IsNull([Com-Doc #2])," ",[Doc #2]) AS [Doc#2] FROM...

I am creating a query with multiple tables. What I need is for the query not to pull what "Is Not Null" in column2 and column1 should not be pulled as well. 1=Yes, 2= No, 3 = NA Example: Column1 Column2 Doc #2 Com-Doc #2 2 Document is missing If (Com-Doc #2) is...

Got it figured out. Thanks!