|
|
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??
--
NotGood[ at ]All
|
|
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[ at ]All" <NotGoodAll[ at ]discussions.microsoft.com> wrote in message
news:0408668A-6130-484D-AB9C-A24D74DB04ED[ at ]microsoft.com...
[Quoted Text] >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??
> --
> NotGood[ at ]All
|
|
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" wrote:
[Quoted Text] > 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[ at ]All" <NotGoodAll[ at ]discussions.microsoft.com> wrote in message
> news:0408668A-6130-484D-AB9C-A24D74DB04ED[ at ]microsoft.com...
> >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??
> > --
> > NotGood[ at ]All
>
>
>
|
|
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"
<openaadobefilefromacommandbutton[ at ]discussions.microsoft.com> wrote in
message news:9F419D1A-2804-4349-97D5-84185F4355C8[ at ]microsoft.com...
[Quoted Text] > 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" wrote:
>
>> 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[ at ]All" <NotGoodAll[ at ]discussions.microsoft.com> wrote in message
>> news:0408668A-6130-484D-AB9C-A24D74DB04ED[ at ]microsoft.com...
>> >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??
>> > --
>> > NotGood[ at ]All
>>
>>
>>
|
|
|