Query Of Totals

[NotGood@All]

I have a table that has some fields, “typeMeetingâ€, (11 types of meetings),
“NumberOfBooksâ€, NumberOfItemsâ€, “NumberOfPagesâ€. I would like to create a
TotalQuery that gives me a break down for the totals numberofpages, books,
items for each type of meeting. Can this be done using 1 query?? Can
someone help through it and to understand it??

 

[Jeff Boyce]

Open a new query in design view.

Add the table.

Add the fields.

Click the "Totals" button ('sigma', looks like a rotated "M").

Use "GroupBy" for the [typeMeeting].

Use "Sum" for the others.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[open a adobe file from a command button]

Jeff, Hi. Thank you very much, it works well. I have one last question on
this subject. The query produced 11 rows and 15 columns of totals, now I
want to put them on a form. How do I bind the text to a textbox?? Example:
row 5, column 7 to a txtSumOfPages.

Open a new query in design view.

Add the table.

Add the fields.

Click the "Totals" button ('sigma', looks like a rotated "M").

Use "GroupBy" for the [typeMeeting].

Use "Sum" for the others.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a table that has some fields, "typeMeeting", (11 types of
meetings),
"NumberOfBooks", NumberOfItems", "NumberOfPages". I would like to create
a
TotalQuery that gives me a break down for the totals numberofpages, books,
items for each type of meeting. Can this be done using 1 query?? Can
someone help through it and to understand it??

 

[Jeff Boyce]

After you've saved your query definition, create a form. When prompted to
point to the data source, point to the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"open a adobe file from a command button"

Jeff, Hi. Thank you very much, it works well. I have one last question
on
this subject. The query produced 11 rows and 15 columns of totals, now I
want to put them on a form. How do I bind the text to a textbox??
Example:
row 5, column 7 to a txtSumOfPages.

Open a new query in design view.

Add the table.

Add the fields.

Click the "Totals" button ('sigma', looks like a rotated "M").

Use "GroupBy" for the [typeMeeting].

Use "Sum" for the others.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a table that has some fields, "typeMeeting", (11 types of
meetings),
"NumberOfBooks", NumberOfItems", "NumberOfPages". I would like to
create
a
TotalQuery that gives me a break down for the totals numberofpages,
books,
items for each type of meeting. Can this be done using 1 query?? Can
someone help through it and to understand it??