Search results

ok, great. do you mind if I keep this thread open and give it a try so I can let you know the results or if I still have issues?

I wonder if I can shorten the "updating" every week to only updating records that have been modified? ok, now I am confusing you again probably. Let me see if I can make sense. every week I export the connections data from the system (to import into the database), I only import the records...

hehe! I probably didn't asked right because I was in a panic for just a second. :) So, it really slowed everything down in the database for the "Update" query to the New CombinedConnections. Is that normal?

that worked thanks again. :)

Paul! I may have marked this solved too soon. I have one more quick question. :confused: We have a field called "Ending" in the tbl_Connections table. We add a date in that field when the assigned role ends because we re-assign it to someone else. So instead of have two paralegals, we would...

YES!!! That is it. Thank you so so so much! I wish I would have posted this yesterday to have this resolved before my quitting time. Looks like I will be staying a little late to clean this up and get it going! Thanks so much again, ever grateful for you!

oh wow, ok, I am sooooo close! ok, so in the CombinedConnections, it is combing EVERY name, and not just the ones that are in the same role. I thought I had it matching on Matter Number, and Role? Here is the SQL STATEMENT: SELECT tbl_Connections.[Matter Number], tbl_Connections.LastName...

no go. I get a pop up box "Enter Parameter value" for tbl_Connections???

I had family from Paonia, Colorado. :) Loved spending lots of time there. I work in government now. It is a new world for me as they are very behind here on the database end of managing their case work. Hoping to find my answers today. talk to you soon.

Hoping for a solution today! It is one of those things that is probably very obvious and I am just totally missing it. Here we go. I work in a law office where we use a case management system to manage our workload. I export the data and use Access to create reporting for the entire...

I am new here and searching for hours to find answers to my Access DB problems when it finally dawned on me to join and post my own thread in hopes of responses. I have played in Access for years, self-taught and what I couldn't thumb through I Googled. Work for a law firm in Dallas as a...