Re: Count records

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.

"Marshall Barton" wrote:

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]


Jean-Francois Gauthier wrote:
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" wrote:

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


Jean-Francois Gauthier wrote:
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" wrote:

Jean-Francois Gauthier wrote:
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.

.

Relevant Pages

  • Re: Bundle Reports and Send to Adobe All at Once
    ... There is no way in Access to bundle multiple reports in a single print job. ... you could try bundling your reports into a single report. ... Dim sWorksheet1 As String ... First you need to tell us what PDF generating software you are using (PDF ...
    (microsoft.public.access.modulesdaovba)
  • Re: Bundle Reports and Send to Adobe All at Once
    ... results in a dialog box popping up which asks for the output file. ... There is no way in Access to bundle multiple reports in a single print job. ... you could try bundling your reports into a single report. ... Dim sWorksheet1 As String ...
    (microsoft.public.access.modulesdaovba)
  • Re: Count records
    ... If your report has a group on the bundle number field, ... the bundle group header or footer section can display the ... "Marshall Barton" wrote: ... Count of all the records shown in the detail portion of the report? ...
    (microsoft.public.access.reports)
  • Re: Count records
    ... feature on the footer of the subform and called it on the main form. ... "Marshall Barton" wrote: ... If you do not have a group on the bundle field, ... Count of all the records shown in the detail portion of the report? ...
    (microsoft.public.access.reports)
  • Re: Count records
    ... Wouldn't it be much better if you had a bundle id field ... "Marshall Barton" wrote: ... Count of all the records shown in the detail portion of the report? ... Header Level: ...
    (microsoft.public.access.reports)