Recent content by sarcasym

Following the link I posted and modifying as needed seems to have helped for the most part. The problem I have now is what is showing on the report isn't what is printing out. I have it grouped by department and have roughly 8 departments showing on the preview but when I print depending it...

I added query parameters to Query 2 for the [Enter Start Date] and [Enter End Date] and now in the report it prompts me for date values twice for each. I guess since the crosstab query creates the columns dynamically I'm also having trouble if lets when one of the values from the IIF statement...

I created the query "Query1": GRESULTS: IIf([Discharge]=[Goal];"Met";IIf([FinalAnswer]>[Goal];"Exceeded";"Not Met")) To determine if each goal was met in the final answer and paired this query with "Query2"(thanks for a starting place ByteMyzer): TRANSFORM...

I'm new to this forum and wanted to thank all of the contributors for the help they've indirectly given me over the past several months. I'll provide the basic over view of the structure first: I have three tables user, question, result user - uid, name, join_date, complete_date question -...