Search results

What a help this list has been. Thanks! My last question for a while, I hope. I have a report that has a single graph in the group header. The graph information is correct for each group, but the R2 value on the trendline is the same on each graph, and the graphs are nowhere near identical...

AWESOME!!!! It works!!!! I just used "Top 1" instead of "Top 3" in the statement. You rock!!!! THANKS! Tania

Thanks for your help. I just stepped back into Access after several years hiatus. I thought this was a simple query and perhaps was just was forgetting some basics. Dratz! Using my noggen more than I thought I had to.:eek: ~Tania

I need this information in the "server" header for a report. I can just link it to the specific server within the text box, right? ~Tania

With the same query in mind, I have one other field that I would like to group on. There are only two variations of the data in that field, at this point. Let me explain it to you and maybe it will help. Field one "server name" (hundreds of records, but only two servers at this time) Field...

Thanks Fuga!!!!!! Most grateful, Tania

Here is the problem. I'm dealing with one table. The data in this table consists of percentages in one field and times in another (all the times are unique). I am trying to get the query to return ONE record consisting of the maximum percentage, but also include the time. In design view, I...