Recent content by MrDix

Wayne, I got it, I created a new query using the following SQL code below. and it works for what I want it. So Now when I created my report I just hide [pkCustomerID] but everything else works fine. Many thanks, for your reply and tips. MrDix...

Thanks Wayne I try it, but I get the following error: You tried to execute a query that does not include specified expression 'Format([StartDate],"yyyymm")'as part of an aggregate function. I am stuck here I can get the total amount grouped by Agent by I can't see to get it so I can have the...

Wayne Thanks, the format is fine but, still I am getting the same results as before 200506 Eric = 1 Eric = 1 Luis = 1 Carlos = 1 200507 Luis = 1 Tammy = 1 Nancy = 1 Nancy = 1 This is not what I am looking for - the format again is fine - but instead of showing Eric = 1 Eric = 1 for the...

Hi, I am using the code below to get the right count of Cases (records) for each agent. SELECT tblCase.Agent, Count(*) AS pkCaseID FROM tblCase GROUP BY tblCase.Agent; it works fine: I have 8 Cases (records) My results are: Eric = 2 Luis = 2 Carlos = 1 Tammy = 1 Nancy = 2 Now, My Issues is...

Thanks Hey Guys Thank you. I got it this time I actually created the Report from scratch instead of using the wizard and it did the trick. Not Sure, what i was doing before but Thank you Much for the info. It help me out alot. Sincerelly, MrDix

I have a call center database Where I can have one customer but many cases. So, right now for testing purposes I only have 3 customers added but I had added 5 cases total: So, I get the right total cases which is five but I can not get the right total customer which is only 3 customers. I...

Hi - I am having an issue with the Dcount funtion on my report. I have a report base on two tables: tblCustomer and tbl Cases I have the following on my Report Footer: Customer: =Count([pkCustomerID]) Case: =Count([pkcaseID]) My problem I come out is: Customer = 5 Cases = 5 The Cases Total...

Hello, I am creating a helpdesk support database. My question is for my Customer Form. As I tested the form I realized that one of my Combo Boxes may not work cause the name may not be the same when the customer calls. Let me Explain: The Combo Box is query from one table with 5 Fields...

Table Design ....... The_Doc_Man -- Hello Thank you -- Yes I am in Dauphine with CNRFC N33 - 8-5996. the Database I upload was from home PC and is only a sample design with dommy data in it. I do understand abou the Security NMCI takes and the whole thing concern about it. As you already know...

First of all, I want to say Thank you to everyone in this forum I have been reading just about every question in each Topic and I have pick up a lot more than I tough I knew. [Thank you]! I not sure how to ask this question or better yet write it. Here is my Situation I work for the NAVY as an...