What are the requirements for Summary Options

[Guest]

I'm still very new to Access, and I'm trying to learn about reports. I know that you can use Summary Options to have the report calculate things like Average, Min, Max, etc. I can do this with Access-provided databases (Northwind). However, everytime I try and do it with one of my personal databases, I can never get the summary options to come up. It doesn't seem to matter what groupings I have. All of my tables are related; forms work well for data entry. Can anyone think of what I'm missing

Thanks!

 

[Duane Hookom]

Do you have any numeric fields in your report's record source? You will not
see the summary options if all you have are text, memo, date, and autonumber
fields. It assumes if you don't have numbers you won't need averages.

--
Duane Hookom
MS Access MVP

I'm still very new to Access, and I'm trying to learn about reports. I

know that you can use Summary Options to have the report calculate things
like Average, Min, Max, etc. I can do this with Access-provided databases
(Northwind). However, everytime I try and do it with one of my personal
databases, I can never get the summary options to come up. It doesn't seem
to matter what groupings I have. All of my tables are related; forms work
well for data entry. Can anyone think of what I'm missing?

 

[Guest]

No, The tables have numbers and percentages in them.

 

[Duane Hookom]

When you look at the report's record source query, are the fields right
aligned or left aligned.

Do you realize that you can get by without using a wizard to specify
totaling and grouping? These properties are all available from design view.