bmyers
Last Activity: Dec 19 '07, 04:33 PM
Joined: Oct 4 '07
Location:
-
Indeed. Thanks again to you and NeoPa for your help with this. "The Scripts" has now made it to my Bookmark list for permanent residency. -
YOU MY FRIEND ARE INGENIUS. That worked great. I will need to do some homework on that one. Thank you so much.Leave a comment:
-
Upon further investigation, I discovered that the function is getting the total number of Closed tickets for Mike from the TABLE itself which is what is stated as the source. So, the function is working correctly. The only issue now is that I was hoping that I could use the Report Source which is the query that prompts the user for a date range. And I thought it would be just matter of simply changing it from the TABLE to the QUERY "ROA_Imaging_Qu eWeb_LINKED_Que ry"...Leave a comment:
-
Well, I think we're getting closer but I'm still getting odd results and don't know how it's calculating the number.
For instance, if you run the Report "ROA Imaging QueWeb Eval Period Report (TEST COPY)" and use a start date of 05/01/07 and an End Date of 08/31/07, you'll see the report period is for that date range only, which that part seems to work. However, if you are look at one of the "Owners", we'll...Leave a comment:
-
Yep, it's just a text field in the original table.
And in regards to the new thread, I don't think I have the option to add an attachment just because the EDIT option doesn't appear for me on any of old posts except for a brief time right after I create a new thread. Otherwise, the only option buttons I see are "REPLY". Only when I create a new thread and then for a short time afterwards do I see the "EDIT"...Leave a comment:
-
Thanks for the pointer but alas it still didn't work. It gives a TOTAL of "0", which I'm not sure where it gets that number. Hmmmm. Thanks for the try though.Leave a comment:
-
Leave a comment:
-
The Dreaded DCOUNT Function in a Report ADDENDUM
After a longer absence than anticipated, I'm finally back trying to figure this thing out. I'm re-posting because even when I reply to the Original Post, I don't have the option to attach files. And this time the attached zipped database is not using the linked table as a source. At least the report in question isn't. I would still greatly appreciate any advice. And please...Leave a comment:
-
Well, if I understand you correctly, if the desired control is a result of evaluating the control data source of the report itself, then I'd have to say not exactly. The report is based on a query that requires the operator to provide the date range. In turn, said query looks at the linked table, "ROAImagingQueW eb-LINKED" which I thought I defined in the DCOUNT function. Which sounds like that may be my issue if I'm trying to look at...Leave a comment:
-
The new post is up. Thanks for the heads up.Leave a comment:
-
Re: The Dreaded DCOUNT Function in a Report
This is a post so that I can attempt to attach the Db that I'm attemping to use the DCOUNT in from an earlier submission. The Report that I'm trying to is "ROA Imaging QueWeb Report by Resource (Sort by Priority)". You'll see the #Error in the Closed Tickets Field. This is where I'm obviously stuck and out of ideas. Thanks so much for you guys' continued help (and patience)....Leave a comment:
-
The saga continues...I'v e read through the FAQ in attempts to post an attachment. However, I don't believe that I have "rights" to view the "browse" button that may or may not appear when replying to a post. Is this a feature that Admin needs to activate for my profile? Thanks again for you guys continuing patience.Leave a comment:
-
Hi again folks,
Just hoping that perhaps someone could offer a few more words of advice. I definitely appreciate the help.
BrianLeave a comment:
-
The operator-entered values are a result of the query which is the Report Source of the Report. The SQL View of that query is below.
...Code:SELECT [ROAImagingQueWeb-LINKED].[Reference #], [ROAImagingQueWeb-LINKED].[Date Reported], [ROAImagingQueWeb-LINKED].Customer, [ROAImagingQueWeb-LINKED].Status, [ROAImagingQueWeb-LINKED].Priority, [ROAImagingQueWeb-LINKED].PROBLEM, [ROAImagingQueWeb-LINKED].Owner FROM [ROAImagingQueWeb-LINKED]
Leave a comment:
-
Sorry about that. Just eager to get this thing resolved. I've now decided to NOT use the query as my control. I was only using a query instead of the actual table with all of the data because the query already had filtered out the needed dates. Therefore, if I now use the table instead of the query as my control source, I will need to add another condition to the DCOUNT function to contain the dates.
...Code:=DCount("[Status]","ROAImagingQueWeb-LINKED","([Status]='Closed')Leave a comment:
-
Thanks for your quick assistance. And you're right, they were different. I have been doing "trial and error" quite a bit and forgot to change the SQL statement back to using the query. If I indeed have the below now corrected with formatting, my goal is really to only use one means of putting the total on the finished report. Whether it be using the embedded SQL statement, which I'm not sure how to even embedd the statement within...Leave a comment:
-
The Dreaded DCOUNT Function in a Report
Good afternoon,
I am attempting to count only those records within a report, which is based on a query, where Status is equal to Closed. I have tried multiple variations of DCOUNT but am continuously receiving the "#ERROR" message in the control source box on the report. Below is the expression that I have tried to use and modify numerous times. Don't know if i'm just simply having syntax issues or my formula is just...
No activity results to display
Leave a comment: