Query Of Totals

  • Thread starter Thread starter NotGood@All
  • Start date Start date
N

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??
 
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
 
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.

Jeff Boyce said:
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

NotGood@All said:
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??
Click to expand...
Click to expand...
 
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.

Jeff Boyce said:
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

NotGood@All said:
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??
Click to expand...
Click to expand...
Click to expand...
 
Back
Top