Search results

I am hoping that someone can help me with my report. I have attached a PDF copy for review. Currently my report is grouped by Judge, then Treatment Center, then Treatment Type. and it does generally look at it should but does not indicate the values in an easy to understand way. I would like it...

I'm having trouble creating getting my report to display the information I want from my query. My query has gathered all the information regarding my clients both their Inpatient Treatment and their Outpatient treatment. Which Treatment Centers they attended, type of treatment, discharge status...

Thank you for your help! I haven't been using Access for a while so I forgot the simple things. Thanks!

Hello, I'm having trouble using the "group by" function in my query. The option in design view is not showing up and I'm not able to figure out what I'm doing wrong. What is there in design view is Field, Table, Sort, Show, Criteria, Or. I seem to be missing the "Totals" option. I'm sure I'm...

Thanks for your input. I given some thought to creating a start date on the master table as you suggested and the only challenge I see with that is clients often have multiple treatment episodes and that date would have to change when this occurs. At this point, I think it would be best to...

I think I understand and no there is not a date field that is consistantly filled out with todays date. If I were to enter all drug tests and noted both positive and negative, could i use the negative test date as the date needed to get an accurate count of days? If so, how would i go about...

That is correct, and the reason is that those clients have not had a positive test yet. When I created the Drug test table I was think that I would record all test results and after more thinking, I thought it would be easier to just record the positive ones which of course would indicate a...

Here you go. I had to go through and change names for privacy reasons but it should work. Thank you!

The expression you sent does the same as I wrote. Where there is not a drug test date, the field remains blank and where there is a drug test date, the field gives the correct number of days clean prior to the positive date.

Here is the SQL: SELECT MasterTable.LastName, MasterTable.FirstName, MasterTable.Sex, ([InpatientTable.DateEntered]-[DOB])/365 AS Age, MasterTable.Judge, MasterTable.Education, InpatientTable.DOC, ([CustodyDateDischarged]-[CustodyDateEntered]) AS JailTime, InpatientTable.TreatmentCenter...

I do have a few different tables. First, i have a main table which is information that does not change i.e. name, DOB, Education, Judge, Probation Officer assigned, etc.. This is connected to an Inpatient Table which has treatment information including date entered and discharged. This is...

Hello, I am tracking the clean time of clients who are coming out of inpatient treatment. I am wondering how to go about calculating this in an ongoing manner in my query. If a client test positive for a substance on a given date my query will calculate the number of days from the discharge date...

Hi, I am a new member as of today. I have used Access on and off throughout my career and am very much a beginner. I work in the Criminal Justice field and am in the US. Thank you in advance for your assistance. Sincerely,