Search results

Hi everyone, Update: I figured out how to run the query how I wanted to, albeit hacked together and not very conducive to changes that may happen in 18 months. Here is the PraxisQuery that does what I want. SELECT PraxisList.SmartPraxisRecommendation FROM DataTable RIGHT JOIN PraxisList ON...

mike60smart, you're exactly right. I should have mentioned that there are currently no offenses in DWI Drugs. There might be at a later date, but right now, the 10th category is empty. There might be offenses that are DWIs combined with drugs, but the group that categorized everything...

mike60smart, I don't know how you did any of that, but that's a very interesting way to approach this problem. I've attached the DWI matrix; the five categories are in bold along the left-hand side. The_Doc_Man, I love your questions, and I think they get at the heart of what I'm trying to do...

Thanks to everyone for trying to help, but no one really seems to be understanding what my problem is. Maybe it would help you if I just explained to you how pretrial works? You all seem to be law-abiding citizens, or you may live in a county that doesn't have a pretrial department, or you might...

(Micron and theDBguy, I'm not ignoring you, I'm just reading all the material that was suggested)

mike60smart, do you have any ideas on what I can do? I downloaded the link and extracted it to my computer and it opened up fine, and theDBguy and June7 seemed to be able to access the file. I really do appreciate you taking the time to try to open the file, and I would gladly accept any help...

Thank you so much for letting me know about closing the db before zipping, mike60smart! I've re-uploaded the zip. theDBguy, I appreciate your thanks, grain of salt notwithstanding :) I'm not quite sure I know how I would go about putting lookup tables into one giant table. Unless you're...

Hi everyone! First of all, shout out to theDBguy for being very friendly and for being extremely helpful! My main data table is called Data Table. I have a field called MostSeriousCharge. This is input using a form called RA Entry Form. I need to lookup the corresponding field called...

I initially inserted [Data Table]! in order to get rid of the dialog boxes, but now I understand that the real solution was to include them in the Record Source. Thank you for that! Solution: Instead of inserting table references in any IIF() statements, include those references properly in the...

Thank you so much for your warm welcome! Attached is a zip of the database in question. Thank you so much for any help you're able to provide! Jacob

Hi everyone, Every time I open a report, I get an "Enter Parameter Value" for an entire table. I had a bunch of these for individual variables, which I found and fixed, but I still don't understand how I can enter a value for an entire table. Would anyone have any idea where I could fix this...