Search results

OK, Thanks to the both of you. It is now working. I just moved it to the Report Footer and the total comes up. It is also placed in the area I want it. I appreciate your patience with me as this is my first experience with access other than tracking phone numbers and addresses. Thanks...

Well, now I cannot get the column totals across the bottom of the report. I get zero when I use =CLng([bjwtruepresinfo.#received]), or #error when I use =Sum([bjwtruepresinfo.#received]). Any suggestions? Thanks David V.

Perfect! Thanks a bunch. Brian, for some reason the report is OK now. Sorry to send you off on something that wasn't wrong. Not sure what happened. All OK now. Thanks David V.

No Problem Brian. I am still trying. The query is still OK, so I may just recreate the report and see what happens.

You are famous Brian. Since your help, I have accomplished so much on this database. You are great. But have run into a nother wall with this report. I made the change as you suggested but it changed everything on the report to #NAME? errors. I reversed it and tried paul's suggestion but it...

I am pulling my hair out in creating a report. The report is fine except for totaling. I need to total all the pending issues for each writer on the far right side of the report and the received, completed, pending on the bottom of the report. Please see the attached and look at the...

WOW!!! I pretty much teared up when I saw the results of your queries. Thank you so much. This will work for me. Also, there is no need for you to do this, but I was wondering what "unecessary criteria" I was using in the pending queries. I am trying to learn access, so it would be...

Thanks Brian. Hope you had a wonderful New Year. I tried to use the query you provided, but keep getting the "Data type mismatch in criteria expression" error. I changed the MinIssueDate to OldestDate since that is what it is called in my DB. Still get the same error. I am attaching an...

This is close, thank you very much. I think you are right that I may need to put some dummy data in. Thanks David V

John, I renamed the queries as you suggested. It does make things easier to keep track of. Thanks David V

Brian, Please do not think that I am ignoring you. I appreciate all help as this is driving me crazy. I want to learn this and I am taking classes, but the class right now is for beginners. I have a book also, but is confusing. And yes, I do have 2 threads. Someone suggested that I start a...

Wow, you are incredibly close. I just need the records where the CompletedDate is Null. What your qry1 is returing is way too many records. I had this problem as well when I combined the query's. it would double and sometimes quadruple the number of items they actually had. Attached are the...

Here is a copy of the database. Thanks David V

Thank you for the assistance. I tried to enter this into the query, but not successful. Probably doing something wrong. here is a screen print of the query. Can you assist in where to enter this information. Do I need to change the "SumofEncounters" to "TruePresPending"? Thanks David V

I certainly appreciate it. Hope your day gets better. I will be leaving shortly, but will be working tomorrow. Have a Happy New Year. Thanks David V>

Thanks John. The query name is "TblIssues True Pres pending". I attached an updated copy of the database. I had made some changes, so this is the newest version so far. I know I need to go back and rename these forms, but I am not sure if these will be the final product so just working with...

I am having a problem with a query. I need to pull a query of pending items for all associates. I created a query for each category( True Pres, Verbal, and CRL). The problem is if the associate does not have an item pending, they will not appear on the list. I need them to appear on the list...

Please? I have tried everything to make this work, but unsuccessful. I am trying to create queries to pull total pending, but need all associates to be listed. The query i have only pulls the associate if they have a pending #. I need for the associate to appear with 0 pending. I am not sure...

Could someone please help me apply the NZ funciton to the below query? Any assistance is greatly appreciated. SELECT DISTINCTROW [TblIssues True Pres Pending].EmployeeID, Sum([TblIssues True Pres Pending].TruePresPending) AS [Sum Of TruePresPending], Sum([TblIssues Verbal...

Perfect. Works great. Thanks so much. Have a wonderful Christmas and Happy New Year. David V.