Search results for query: *

works great. thanks.

this is exactly what i had in mind. I will give it a try and let you know how it went. thanks in advance.

I would like the database to open with absolutely no ribbons. And i don't want the user to have to click anything to minimize or close it. That was always possible in past versions, but I can't figure out how to do that when creating a new database in 2007 version.

let me clarify. I would like it to be not visible when users first open the database.

When creating an Access2007 database, is there a simple way to have the entire ribbon to be not visible at all? I read all through help and I can't seem to figure out how to make it go away.

Most excellent MajP, now I understand. Use my original query and then get the subtotals from that one in a separate query. Thank you very much for your assistance.

It sounded so simple, but I'm having a lot of trouble creating this new query. My original query with all of my field names is 2 posts up. Are you able to give me a little assist please?

I've never done that before. I've done subforms, so I'm assuming it's a similar concept. So would I create a whole new query such as duane suggested above, and then use that as the record source for the few fields that I need sub totals on? And I'm also assuming they will be linked by some...

I was thinking that If I create sums in my query, then it would not show each individual record in the query. I want it to continue to show each individual record in the query becauase I use the detailed record information in my report also. That is why I was just hoping to find a way to total...

moved topic to report forum.

I have a query and it is doing just as I want it to. It displays each record, and also has a field called 'status' that can have five different values. The possible choices in this field are 'selectstatus'(the default), the other choices are, 'monitoring', 'working resolution','deferred', or...

That's exactly what I need.

I actually do have group by right now. I feel that my query is working exactly like I would expect it would. here is my query. I need the query to continue to show the details for each record, but I need the grand totals for each of the category values. that's why I wanted to find a way...

everything is good in the query, I just need to figure out how to get the totals in the report. If i do totals in the query, then it won't output each individual record, and i need that information also. That's why i was trying to get totals in the report.

bigred, I need the query to output all of the fields just like in gruuuu's post, however on the report, I want to be able to have a total for each value. The reason why I need it this way is because the source of the report, is the query, and there are many other fields on the report that are...

Gruuuu, that IS exactly how my query results look now. What I would like to do now, is in my report to show the totals for each of those value types. Using your example above: I would like the report to say: selectstatus 9 monitoring 1 working resolution 16 deferred 1 closed 4

I did manage to get the query set up so It has a column that shows a count of each value type, however how would I go about collecting a total for each different value type? Would I be able to get a total for each value in a report somehow? In my query, it shows approx 50 some records and I...

well I need to count the occurances of each type of possible variables in that field. the possible choices in this field are 'selectstatus' (the default), the other choices are, 'monitoring', 'working resolution','deferred', or 'closed'.

I have a report that its record source is a query. In the query I have a field called 'status'. In that field there could be 5 different possible text values.(these values came from a combo box on a form) Is there a way for me to count the number of occurances of each value? The reason for...

Oh, I see. Well thanks again. I greatly appreciate your help.