I am trying to display the total amount of times I sent product out for
repair by Serial # in the Report Footer. The field name is Sn#. I would
like for it to display something like this:

Serial # Total Repairs
M0345 4
M0241 6
M0318 1

Can Anyone give me a simple solution?

Thank you,

Difficult to give a definitive answer without knowing what your tables look
like, but you should be able to create a Totals query.

You do this by choosing the table that has the details required to arrive at
the totals below and dragging the Serial Number field and one other field
into the grid. Change the query to a Totals query (click on the Sigma button
on the button bar, or choose Totals on the View menu). Leave the default
"Group By" under the Serial Number field, and change it to "Count" under the
other field.

You can then create a report based on that query, and use it as a subreport.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Ron" <(E-Mail Removed)> wrote in message
news:C37635E6-CBBD-4DCA-BCCB-(E-Mail Removed)...
> I am trying to display the total amount of times I sent product out for
> repair by Serial # in the Report Footer. The field name is Sn#. I would
> like for it to display something like this:
>
> Serial # Total Repairs
> M0345 4
> M0241 6
> M0318 1
>
> Can Anyone give me a simple solution?
>
> Thank you,

"Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:(E-Mail Removed)...
> Difficult to give a definitive answer without knowing what your tables
> look
> like, but you should be able to create a Totals query.
>
> You do this by choosing the table that has the details required to arrive
> at
> the totals below and dragging the Serial Number field and one other field
> into the grid. Change the query to a Totals query (click on the Sigma
> button
> on the button bar, or choose Totals on the View menu). Leave the default
> "Group By" under the Serial Number field, and change it to "Count" under
> the
> other field.
>
> You can then create a report based on that query, and use it as a
> subreport.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Ron" <(E-Mail Removed)> wrote in message
> news:C37635E6-CBBD-4DCA-BCCB-(E-Mail Removed)...
>> I am trying to display the total amount of times I sent product out for
>> repair by Serial # in the Report Footer. The field name is Sn#. I would
>> like for it to display something like this:
>>
>> Serial # Total Repairs
>> M0345 4
>> M0241 6
>> M0318 1
>>
>> Can Anyone give me a simple solution?
>>
>> Thank you,
>
>

I was able to get the Serial # to display just once in the query. But what I
can't still figure out is how to get a total of how many times I actually
enter the serial # in to the table that I created for sending equipment out
for repair. Can someone help me with the Count?

"Ron" wrote:

> I am trying to display the total amount of times I sent product out for
> repair by Serial # in the Report Footer. The field name is Sn#. I would
> like for it to display something like this:
>
> Serial # Total Repairs
> M0345 4
> M0241 6
> M0318 1
>
> Can Anyone give me a simple solution?
>
> Thank you,

Did you try the suggestion I made?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Ron" <(E-Mail Removed)> wrote in message
news:FB942E15-C0D2-464C-A0BB-(E-Mail Removed)...
>I was able to get the Serial # to display just once in the query. But what
>I
> can't still figure out is how to get a total of how many times I actually
> enter the serial # in to the table that I created for sending equipment
> out
> for repair. Can someone help me with the Count?
>
> "Ron" wrote:
>
>> I am trying to display the total amount of times I sent product out for
>> repair by Serial # in the Report Footer. The field name is Sn#. I would
>> like for it to display something like this:
>>
>> Serial # Total Repairs
>> M0345 4
>> M0241 6
>> M0318 1
>>
>> Can Anyone give me a simple solution?
>>
>> Thank you,

I did try it. I have it setup as a Group for the Sn# field, but what is the
other field?

"Douglas J. Steele" wrote:

> Did you try the suggestion I made?
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Ron" <(E-Mail Removed)> wrote in message
> news:FB942E15-C0D2-464C-A0BB-(E-Mail Removed)...
> >I was able to get the Serial # to display just once in the query. But what
> >I
> > can't still figure out is how to get a total of how many times I actually
> > enter the serial # in to the table that I created for sending equipment
> > out
> > for repair. Can someone help me with the Count?
> >
> > "Ron" wrote:
> >
> >> I am trying to display the total amount of times I sent product out for
> >> repair by Serial # in the Report Footer. The field name is Sn#. I would
> >> like for it to display something like this:
> >>
> >> Serial # Total Repairs
> >> M0345 4
> >> M0241 6
> >> M0318 1
> >>
> >> Can Anyone give me a simple solution?
> >>
> >> Thank you,
>
>
>

Any field you want in the table, preferably one that is never null.

In fact, it can be Sn# a second time if you want.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Ron" <(E-Mail Removed)> wrote in message
news:64EA7ACE-06DB-4FB1-909D-(E-Mail Removed)...
>I did try it. I have it setup as a Group for the Sn# field, but what is
>the
> other field?
>
> "Douglas J. Steele" wrote:
>
>> Did you try the suggestion I made?
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "Ron" <(E-Mail Removed)> wrote in message
>> news:FB942E15-C0D2-464C-A0BB-(E-Mail Removed)...
>> >I was able to get the Serial # to display just once in the query. But
>> >what
>> >I
>> > can't still figure out is how to get a total of how many times I
>> > actually
>> > enter the serial # in to the table that I created for sending equipment
>> > out
>> > for repair. Can someone help me with the Count?
>> >
>> > "Ron" wrote:
>> >
>> >> I am trying to display the total amount of times I sent product out
>> >> for
>> >> repair by Serial # in the Report Footer. The field name is Sn#. I
>> >> would
>> >> like for it to display something like this:
>> >>
>> >> Serial # Total Repairs
>> >> M0345 4
>> >> M0241 6
>> >> M0318 1
>> >>
>> >> Can Anyone give me a simple solution?
>> >>
>> >> Thank you,
>>
>>
>>

I setup a second field with Sn# as well. Instead of using Group By in this
second field I chose count. When I ran the query, the table showed the
Serial #s correctly, all of the counts for each serial # were 1. I need it
to display the # of times I sent each serial # out for repair. I know most
of them were more than once. Any suggestions?

"Douglas J. Steele" wrote:

> Any field you want in the table, preferably one that is never null.
>
> In fact, it can be Sn# a second time if you want.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Ron" <(E-Mail Removed)> wrote in message
> news:64EA7ACE-06DB-4FB1-909D-(E-Mail Removed)...
> >I did try it. I have it setup as a Group for the Sn# field, but what is
> >the
> > other field?
> >
> > "Douglas J. Steele" wrote:
> >
> >> Did you try the suggestion I made?
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no private e-mails, please)
> >>
> >>
> >> "Ron" <(E-Mail Removed)> wrote in message
> >> news:FB942E15-C0D2-464C-A0BB-(E-Mail Removed)...
> >> >I was able to get the Serial # to display just once in the query. But
> >> >what
> >> >I
> >> > can't still figure out is how to get a total of how many times I
> >> > actually
> >> > enter the serial # in to the table that I created for sending equipment
> >> > out
> >> > for repair. Can someone help me with the Count?
> >> >
> >> > "Ron" wrote:
> >> >
> >> >> I am trying to display the total amount of times I sent product out
> >> >> for
> >> >> repair by Serial # in the Report Footer. The field name is Sn#. I
> >> >> would
> >> >> like for it to display something like this:
> >> >>
> >> >> Serial # Total Repairs
> >> >> M0345 4
> >> >> M0241 6
> >> >> M0318 1
> >> >>
> >> >> Can Anyone give me a simple solution?
> >> >>
> >> >> Thank you,
> >>
> >>
> >>
>
>
>