Count records

[Jean-Francois Gauthier]

Hi,

I am trying to have the following done:

I would like to create a report that can be printed from a form that would
show the following:

Header Level:

- Department Name:
- Document Type
- Bundle No:
- Assigned To:
- Number of Records in Bundle (Count - Details)

Detail Level (in columns)

Tracking Number Client Document Reference Number

I would also like to have beside these three columns to go with each record
a blank field for handwriting, therefore unbound and then have a box
(checkbox) that is blnak for the user to manually check off.

Is this possible?

Thank you for your help.

 

[Marshall Barton]

I would like to create a report that can be printed from a form that would
show the following:

Header Level:

- Department Name:
- Document Type
- Bundle No:
- Assigned To:
- Number of Records in Bundle (Count - Details)

Detail Level (in columns)

Tracking Number Client Document Reference Number

I would also like to have beside these three columns to go with each record
a blank field for handwriting, therefore unbound and then have a box
(checkbox) that is blnak for the user to manually check off.

Sounds like all you want is two rectangles in the detail
section. If so, just open the report in design view and add
them from the Toolbox toolbar.

 

[Jean-Francois Gauthier]

Hi Marshall,

Any idea how I can get the "Number of Records In Bundle"....basically a
Count of all the records shown in the detail portion of the report?

Thanks,

JF

 

[Marshall Barton]

You can use a text box in any header or footer (except page)
with the expression =Count(*)

 

[Jean-Francois Gauthier]

Hi Marshall,

Thanks for the reply.

I am trying to save this Count value in my bundle database. This is
supposed to count the number of records that are in a bundle. I was able to
get this done and when I have a new bundle number added to a record in a new
bundle and do an append query, it returns the information I need in my bundle
table. In this I have the following info. Bundle#, Department, Document
Type, Number of Records and Assigned to (this is a value that the user will
update itself and does not come from the records table). My only problem
at this point in time is that if I edit a record and change it bundle number
or remove its bundle number (therefore unbundling it), when I hit the append
query to run, the count does not refresh to the new value either higehr or
lower depending if I added records to the bundle# or removed some. Any idea
why that could be?

You can use a text box in any header or footer (except page)
with the expression =Count(*)
--
Marsh
MVP [MS Access]

Any idea how I can get the "Number of Records In Bundle"....basically a
Count of all the records shown in the detail portion of the report?

 

[Marshall Barton]

That's one good reason why you should not store calculated
values in a table. There is no good way to do it either.

Wouldn't it be much better if you had a bundle id field
instead? This way you count the numbe of items in any
specific bundle anytime you wanted.

 

[Jean-Francois Gauthier]

Hi Marshall,

That is basically what I want. I have in table tbl_bundle, a "bundleNo"
field which is alpha-numeric and is to be entered by the user when inputting
a record in the Bundle# field in tbl_docinput. An append query then
returns the Bundle# to BundleNo of the tbl_bundle as one record. Basically
what I want to do is have somethign to count how many records that are in a
bundle. So basically how many Bundle# in BundleNo X.

Thanks for your help on this. I entered a new ticket requesting help
regarding reports and printing, and it all falls I believe arond the same
issue.

That's one good reason why you should not store calculated
values in a table. There is no good way to do it either.

Wouldn't it be much better if you had a bundle id field
instead? This way you count the numbe of items in any
specific bundle anytime you wanted.
--
Marsh
MVP [MS Access]

I am trying to save this Count value in my bundle database. This is
supposed to count the number of records that are in a bundle. I was able to
get this done and when I have a new bundle number added to a record in a new
bundle and do an append query, it returns the information I need in my bundle
table. In this I have the following info. Bundle#, Department, Document
Type, Number of Records and Assigned to (this is a value that the user will
update itself and does not come from the records table). My only problem
at this point in time is that if I edit a record and change it bundle number
or remove its bundle number (therefore unbundling it), when I hit the append
query to run, the count does not refresh to the new value either higehr or
lower depending if I added records to the bundle# or removed some. Any idea
why that could be?

 

[Marshall Barton]

If your report has a group on the bundle number field, then
the bundle group header or footer section can display the
number of details by using an =Count(*) text box.

If you do not have a group on the bundle field, then I don't
understand what want to do.

 

[Jean-Francois Gauthier]

Hi Marshall,

Thanks for the reply. I did the as you stated earlier. Put the count
feature on the footer of the subform and called it on the main form. Thanks
for your help

If your report has a group on the bundle number field, then
the bundle group header or footer section can display the
number of details by using an =Count(*) text box.

If you do not have a group on the bundle field, then I don't
understand what want to do.
--
Marsh
MVP [MS Access]

That is basically what I want. I have in table tbl_bundle, a "bundleNo"
field which is alpha-numeric and is to be entered by the user when inputting
a record in the Bundle# field in tbl_docinput. An append query then
returns the Bundle# to BundleNo of the tbl_bundle as one record. Basically
what I want to do is have somethign to count how many records that are in a
bundle. So basically how many Bundle# in BundleNo X.

Thanks for your help on this. I entered a new ticket requesting help
regarding reports and printing, and it all falls I believe arond the same
issue.