Search results for query: *

Yea...it didn't. At first I couldn't get it..but now I do. What I still need is a total. I get this. Joe Blow CALL#`870948572049587 1 CALL#`870948572049590 1 CALL#`870948572049836 1 How do I surpress THOSE calls to read JOE BLOW 3 ? thanks ssssssssssssoooooooooooooooooooo much!

Ah ha! I did an 'insert summary' on call#, and it did give me a total for the '3' transactions as '1' call. That's good! However, It is showing all the calls...and what I really need is a total of the calls by officer. ie. officer 1015 Jim James 876 1071 Joe Blow 765 etc. Is that...

I grouped it as instructed..and actual end-up with a count of 'one' for all the calls??? I would really love to 'pay' someone for assistance. Is there an 'expert for hire' type service that you are part of through tek-tips?

FIRST...I am REALLY green, so bear with me. I have read the thread on suppressing duplicate records...however I have a problem. I work with a law enforcement database, and there is no field UNIQUE to the record. Eg. I have OFFICER, DATE, CALL NUMBER, COMPLAINT. I need to count how many...

Hot diggity! (sp) It worked. Thanks so much!!!!

Hi, This is my first question. I need to do what first gal did, but I need to go back 21 days. I tried a variation of the 'year' suggestion that was provided: Incident.Date_Incident} in Dateadd ("dd",-21,CurrentDate) to currentdate but am getting the following error: Argument #1 of...