Summary query, sum by



I don't understand what makes a summary query sort to certain parameters.
Sometimes when I go for a summary query the query asks if I want it summed by
day, month, year etc.. other times it doesn't. How can I make it ask me when
it doesn't it always seems to not ask particularily when I want it to. I
hope this makes sense. Thanks



John Spencer

It sounds as if you are using the wizard to create the query. If so, I
believe that the wizard only asks about summaries when it sees a date or
number field in the select clause. I'm not sure about that as it has been
years since I've used the wizard to create a query.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

summary query 5
Summary Query on Results of a Parameter Query 1
Summary Query - grouping by Month 1
summaries of summaries.. 1
Summary 1
system summary 1
report summary 1
Summary Table 0