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...

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...

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,