reports and queries

Good afternoon,

i'm trying to produce a report that will display different status level and
how many are in each level. there are 4 levels ( open, pending, waiting,
closed)

under each level there is a id number that will be given - i need the report
not only to tell me how many i have under each status level but to give me
the id's that are under that level also. for example lets say i have 4
tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status

how can i get the report to not only show me these totals but
the 4 under open - 2 uder pending - 5 under waiting and 10 under close...
thank you for you help it is truly appreciated.

tryn2learn wrote:
i'm trying to produce a report that will display different status level and
how many are in each level. there are 4 levels ( open, pending, waiting,
closed)

under each level there is a id number that will be given - i need the report
not only to tell me how many i have under each status level but to give me
the id's that are under that level also. for example lets say i have 4
tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status

how can i get the report to not only show me these totals but
the 4 under open - 2 uder pending - 5 under waiting and 10 under close...
thank you for you help it is truly appreciated.


Use the report's Sorting and Grouping window (View menu) to
create a group on the status level field. Select Yes for
the Group Header and Footer properties in the lower part of
the window.

Then put the status level text box in the group header
section.

Put a text box with the expression =Count(*) in the group
footer section.

Put the id number text box in the detail section.

--
Marsh
MVP [MS Access]

thank you i was able to group by using the report wizard and "status" as the
grouping item... however i'm still unable to get the total cout of each field.

i see the =count(*) but i'm not able to get it to work, i appreciate your
patience in this matter.

"Marshall Barton" wrote:

tryn2learn wrote:
i'm trying to produce a report that will display different status level and
how many are in each level. there are 4 levels ( open, pending, waiting,
closed)

under each level there is a id number that will be given - i need the report
not only to tell me how many i have under each status level but to give me
the id's that are under that level also. for example lets say i have 4
tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status

how can i get the report to not only show me these totals but
the 4 under open - 2 uder pending - 5 under waiting and 10 under close...
thank you for you help it is truly appreciated.


Use the report's Sorting and Grouping window (View menu) to
create a group on the status level field. Select Yes for
the Group Header and Footer properties in the lower part of
the window.

Then put the status level text box in the group header
section.

Put a text box with the expression =Count(*) in the group
footer section.

Put the id number text box in the detail section.

--
Marsh
MVP [MS Access]

Using a wizard to mess with a report can cause confusion.
From here on, work on the report in design view.

What do you mean by "see the =count(*)"?

Telling us "i'm not able to get it to work" doesn't provide
any clues about what might be wrong. It would be more
useful if you explained what the report displayed in the
group footer text box? As a wild guess, all I can suggest
is to double check that you put the =Count(*) in the text
box's Control Source property instead of some other
ineffective place such as a label's caption.
--
Marsh
MVP [MS Access]


tryn2learn wrote:
thank you i was able to group by using the report wizard and "status" as the
grouping item... however i'm still unable to get the total cout of each field.

i see the =count(*) but i'm not able to get it to work, i appreciate your
patience in this matter.

"Marshall Barton" wrote:

tryn2learn wrote:
i'm trying to produce a report that will display different status level and
how many are in each level. there are 4 levels ( open, pending, waiting,
closed)

under each level there is a id number that will be given - i need the report
not only to tell me how many i have under each status level but to give me
the id's that are under that level also. for example lets say i have 4
tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status

how can i get the report to not only show me these totals but
the 4 under open - 2 uder pending - 5 under waiting and 10 under close...
thank you for you help it is truly appreciated.


Use the report's Sorting and Grouping window (View menu) to
create a group on the status level field. Select Yes for
the Group Header and Footer properties in the lower part of
the window.

Then put the status level text box in the group header
section.

Put a text box with the expression =Count(*) in the group
footer section.

Put the id number text box in the detail section.

okay, Its telling me how many groups i have, but not home many within each
group
example ( i have two items under "open" status and one items under
"resolved' status but it's not showing me that).

it looks like this:

Collective Summary:
Open 2 Work In Progress 1 Hold 1 Resolved 1
Detailed Summary:
Open: 2
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law

Work In Progress: 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law

Hold 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law
Resolved 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A


"Marshall Barton" wrote:

Using a wizard to mess with a report can cause confusion.
From here on, work on the report in design view.

What do you mean by "see the =count(*)"?

Telling us "i'm not able to get it to work" doesn't provide
any clues about what might be wrong. It would be more
useful if you explained what the report displayed in the
group footer text box? As a wild guess, all I can suggest
is to double check that you put the =Count(*) in the text
box's Control Source property instead of some other
ineffective place such as a label's caption.
--
Marsh
MVP [MS Access]


tryn2learn wrote:
thank you i was able to group by using the report wizard and "status" as the
grouping item... however i'm still unable to get the total cout of each field.

i see the =count(*) but i'm not able to get it to work, i appreciate your
patience in this matter.

"Marshall Barton" wrote:

tryn2learn wrote:
i'm trying to produce a report that will display different status level and
how many are in each level. there are 4 levels ( open, pending, waiting,
closed)

under each level there is a id number that will be given - i need the report
not only to tell me how many i have under each status level but to give me
the id's that are under that level also. for example lets say i have 4
tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status

how can i get the report to not only show me these totals but
the 4 under open - 2 uder pending - 5 under waiting and 10 under close...
thank you for you help it is truly appreciated.


Use the report's Sorting and Grouping window (View menu) to
create a group on the status level field. Select Yes for
the Group Header and Footer properties in the lower part of
the window.

Then put the status level text box in the group header
section.

Put a text box with the expression =Count(*) in the group
footer section.

Put the id number text box in the detail section.

sorry i meant i want it to look like this:

it looks like this:

Collective Summary:
Open 2 Work In Progress 1 Hold 1 Resolved 1
Detailed Summary:
Open: 2
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law

Work In Progress: 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law

Hold 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law
Resolved 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A


"tryn2learn" wrote:

okay, Its telling me how many groups i have, but not home many within each
group
example ( i have two items under "open" status and one items under
"resolved' status but it's not showing me that).

it looks like this:

Collective Summary:
Open 2 Work In Progress 1 Hold 1 Resolved 1
Detailed Summary:
Open: 2
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law

Work In Progress: 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law

Hold 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law
Resolved 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A


"Marshall Barton" wrote:

Using a wizard to mess with a report can cause confusion.
From here on, work on the report in design view.

What do you mean by "see the =count(*)"?

Telling us "i'm not able to get it to work" doesn't provide
any clues about what might be wrong. It would be more
useful if you explained what the report displayed in the
group footer text box? As a wild guess, all I can suggest
is to double check that you put the =Count(*) in the text
box's Control Source property instead of some other
ineffective place such as a label's caption.
--
Marsh
MVP [MS Access]


tryn2learn wrote:
thank you i was able to group by using the report wizard and "status" as the
grouping item... however i'm still unable to get the total cout of each field.

i see the =count(*) but i'm not able to get it to work, i appreciate your
patience in this matter.

"Marshall Barton" wrote:

tryn2learn wrote:
i'm trying to produce a report that will display different status level and
how many are in each level. there are 4 levels ( open, pending, waiting,
closed)

under each level there is a id number that will be given - i need the report
not only to tell me how many i have under each status level but to give me
the id's that are under that level also. for example lets say i have 4
tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status

how can i get the report to not only show me these totals but
the 4 under open - 2 uder pending - 5 under waiting and 10 under close...
thank you for you help it is truly appreciated.


Use the report's Sorting and Grouping window (View menu) to
create a group on the status level field. Select Yes for
the Group Header and Footer properties in the lower part of
the window.

Then put the status level text box in the group header
section.

Put a text box with the expression =Count(*) in the group
footer section.

Put the id number text box in the detail section.

It's good to know what it should look like, but What does it
actually look like?

You said "Its telling me how many groups i have", does that
mean "it", whatever "it" is, displays the number 4? If so,
that would imply that you are not grouping the report and
that the items are in a subreport. It probably also implies
that you put the count text box in the report footer instead
of in the **group** header or footer section.

What/Where did this Collective Summary part come from???

If you are not seeing some data that you can guarantee is in
the report's record source query, then there a bigger
problem than what you are asking about. You better explain
what records the query actually is selecting by itself,
without using the report.
--
Marsh
MVP [MS Access]


tryn2learn wrote:

okay, Its telling me how many groups i have, but not home many within each
group
example ( i have two items under "open" status and one items under
"resolved' status but it's not showing me that).

it looks like this:

Collective Summary:
Open 2 Work In Progress 1 Hold 1 Resolved 1
Detailed Summary:
Open: 2
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law

Work In Progress: 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law

Hold 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law
Resolved 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A


"Marshall Barton" wrote:

Using a wizard to mess with a report can cause confusion.
From here on, work on the report in design view.

What do you mean by "see the =count(*)"?

Telling us "i'm not able to get it to work" doesn't provide
any clues about what might be wrong. It would be more
useful if you explained what the report displayed in the
group footer text box? As a wild guess, all I can suggest
is to double check that you put the =Count(*) in the text
box's Control Source property instead of some other
ineffective place such as a label's caption.


tryn2learn wrote:
thank you i was able to group by using the report wizard and "status" as the
grouping item... however i'm still unable to get the total cout of each field.

i see the =count(*) but i'm not able to get it to work, i appreciate your
patience in this matter.

"Marshall Barton" wrote:

tryn2learn wrote:
i'm trying to produce a report that will display different status level and
how many are in each level. there are 4 levels ( open, pending, waiting,
closed)

under each level there is a id number that will be given - i need the report
not only to tell me how many i have under each status level but to give me
the id's that are under that level also. for example lets say i have 4
tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status

how can i get the report to not only show me these totals but
the 4 under open - 2 uder pending - 5 under waiting and 10 under close...
thank you for you help it is truly appreciated.


Use the report's Sorting and Grouping window (View menu) to
create a group on the status level field. Select Yes for
the Group Header and Footer properties in the lower part of
the window.

Then put the status level text box in the group header
section.

Put a text box with the expression =Count(*) in the group
footer section.

Put the id number text box in the detail section.

you're right, this is how it currently looks:
Status Open

TechReq # Assigned To: Manager Requested:
123456789 P Port A Law

TechReq # Assigned To: Manager Requested:
123456789 T Zach A Law

Status Resolved

TechReq # Assigned To: Manager Requested:
123456789 P Port A Law

the report is partially grouped like i want. The "open" is together and the
"resolved" is together with the information for each below it, but i don't
know how to add the collective summary line where is shows how many are in
each:

Open 2 Resolved 1

sorry for not being able to explain myself, but i again appreciate your help
and patience with me
"Marshall Barton" wrote:

It's good to know what it should look like, but What does it
actually look like?

You said "Its telling me how many groups i have", does that
mean "it", whatever "it" is, displays the number 4? If so,
that would imply that you are not grouping the report and
that the items are in a subreport. It probably also implies
that you put the count text box in the report footer instead
of in the **group** header or footer section.

What/Where did this Collective Summary part come from???

If you are not seeing some data that you can guarantee is in
the report's record source query, then there a bigger
problem than what you are asking about. You better explain
what records the query actually is selecting by itself,
without using the report.
--
Marsh
MVP [MS Access]


tryn2learn wrote:

okay, Its telling me how many groups i have, but not home many within each
group
example ( i have two items under "open" status and one items under
"resolved' status but it's not showing me that).

it looks like this:

Collective Summary:
Open 2 Work In Progress 1 Hold 1 Resolved 1
Detailed Summary:
Open: 2
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law

Work In Progress: 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law

Hold 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law
Resolved 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A


"Marshall Barton" wrote:

Using a wizard to mess with a report can cause confusion.
From here on, work on the report in design view.

What do you mean by "see the =count(*)"?

Telling us "i'm not able to get it to work" doesn't provide
any clues about what might be wrong. It would be more
useful if you explained what the report displayed in the
group footer text box? As a wild guess, all I can suggest
is to double check that you put the =Count(*) in the text
box's Control Source property instead of some other
ineffective place such as a label's caption.


tryn2learn wrote:
thank you i was able to group by using the report wizard and "status" as the
grouping item... however i'm still unable to get the total cout of each field.

i see the =count(*) but i'm not able to get it to work, i appreciate your
patience in this matter.

"Marshall Barton" wrote:

tryn2learn wrote:
i'm trying to produce a report that will display different status level and
how many are in each level. there are 4 levels ( open, pending, waiting,
closed)

under each level there is a id number that will be given - i need the report
not only to tell me how many i have under each status level but to give me
the id's that are under that level also. for example lets say i have 4
tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status

how can i get the report to not only show me these totals but
the 4 under open - 2 uder pending - 5 under waiting and 10 under close...
thank you for you help it is truly appreciated.


Use the report's Sorting and Grouping window (View menu) to
create a group on the status level field. Select Yes for
the Group Header and Footer properties in the lower part of
the window.

Then put the status level text box in the group header
section.

Put a text box with the expression =Count(*) in the group
footer section.

Put the id number text box in the detail section.

I have read through our prior's and retried it is now working... thank you
again for your help and support in this.

"tryn2learn" wrote:

you're right, this is how it currently looks:
Status Open

TechReq # Assigned To: Manager Requested:
123456789 P Port A Law

TechReq # Assigned To: Manager Requested:
123456789 T Zach A Law

Status Resolved

TechReq # Assigned To: Manager Requested:
123456789 P Port A Law

the report is partially grouped like i want. The "open" is together and the
"resolved" is together with the information for each below it, but i don't
know how to add the collective summary line where is shows how many are in
each:

Open 2 Resolved 1

sorry for not being able to explain myself, but i again appreciate your help
and patience with me
"Marshall Barton" wrote:

It's good to know what it should look like, but What does it
actually look like?

You said "Its telling me how many groups i have", does that
mean "it", whatever "it" is, displays the number 4? If so,
that would imply that you are not grouping the report and
that the items are in a subreport. It probably also implies
that you put the count text box in the report footer instead
of in the **group** header or footer section.

What/Where did this Collective Summary part come from???

If you are not seeing some data that you can guarantee is in
the report's record source query, then there a bigger
problem than what you are asking about. You better explain
what records the query actually is selecting by itself,
without using the report.
--
Marsh
MVP [MS Access]


tryn2learn wrote:

okay, Its telling me how many groups i have, but not home many within each
group
example ( i have two items under "open" status and one items under
"resolved' status but it's not showing me that).

it looks like this:

Collective Summary:
Open 2 Work In Progress 1 Hold 1 Resolved 1
Detailed Summary:
Open: 2
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law

Work In Progress: 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law

Hold 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law
Resolved 1
TechReq # 123456789 Assigned To:P Porter Manager Requested: A


"Marshall Barton" wrote:

Using a wizard to mess with a report can cause confusion.
From here on, work on the report in design view.

What do you mean by "see the =count(*)"?

Telling us "i'm not able to get it to work" doesn't provide
any clues about what might be wrong. It would be more
useful if you explained what the report displayed in the
group footer text box? As a wild guess, all I can suggest
is to double check that you put the =Count(*) in the text
box's Control Source property instead of some other
ineffective place such as a label's caption.


tryn2learn wrote:
thank you i was able to group by using the report wizard and "status" as the
grouping item... however i'm still unable to get the total cout of each field.

i see the =count(*) but i'm not able to get it to work, i appreciate your
patience in this matter.

"Marshall Barton" wrote:

tryn2learn wrote:
i'm trying to produce a report that will display different status level and
how many are in each level. there are 4 levels ( open, pending, waiting,
closed)

under each level there is a id number that will be given - i need the report
not only to tell me how many i have under each status level but to give me
the id's that are under that level also. for example lets say i have 4
tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status

how can i get the report to not only show me these totals but
the 4 under open - 2 uder pending - 5 under waiting and 10 under close...
thank you for you help it is truly appreciated.


Use the report's Sorting and Grouping window (View menu) to
create a group on the status level field. Select Yes for
the Group Header and Footer properties in the lower part of
the window.

Then put the status level text box in the group header
section.

Put a text box with the expression =Count(*) in the group
footer section.

Put the id number text box in the detail section.

That's good to hear, but what did you do to get the summary
part? I just found out that was the problem and haven't had
a chance to suggest ways to deal with it (I think a
multi-column subreport might be the most appropriate
approach).
--
Marsh
MVP [MS Access]


tryn2learn wrote:
I have read through our prior's and retried it is now working... thank you
again for your help and support in this.

"tryn2learn" wrote:
you're right, this is how it currently looks:
Status Open

TechReq # Assigned To: Manager Requested:
123456789 P Port A Law

TechReq # Assigned To: Manager Requested:
123456789 T Zach A Law

Status Resolved

TechReq # Assigned To: Manager Requested:
123456789 P Port A Law

the report is partially grouped like i want. The "open" is together and the
"resolved" is together with the information for each below it, but i don't
know how to add the collective summary line where is shows how many are in
each:

Open 2 Resolved 1