[Question] How to count all entries in a field

[jackshield]

WOW!

down to a little over 2mb after compact & repair, under 1/2mb after zip.

is there a place on forum to post?

 

[boblarson]

WOW!

down to a little over 2mb after compact & repair, under 1/2mb after zip.

is there a place on forum to post?

Just post in this thread. Follow these directions:
http://www.access-programmers.co.uk/forums/showthread.php?t=140587

 

[jackshield]

Upon launching file, (password = "DRAFTOKC")

from the "Main Switchboard"

the report "Print Entire HECP Listing"

I added (copied) a text box, upper left, in header, next to "HECP"

I need that to give me a total count of items reported

I assumed it needed to count "ID_NUMBER" in the "ID_NUMBER header" section

 

[boblarson]

Okay, delete the text box (it appears to be corrupt) and replace it with another one. I just copied the VERIFIED count one. And then control source should be:

=DCount("*","OKC_MCC")

 

[jackshield]

Okay, delete the text box (it appears to be corrupt) and replace it with another one. I just copied the VERIFIED count one. And then control source should be:

=DCount("*","OKC_MCC")

Is that reporting the total number of items populated on this report, or the total on items on that table (OKC_MCC), or is that the same?

 

[boblarson]

Is that reporting the total number of items populated on this report, or the total on items on that table (OKC_MCC), or is that the same?

It would be the total number of items in the table which should equal both the verified and unverified items added together. That is more efficient than trying to do Dcounts for each part and adding them together.

 

[jackshield]

I need to know how many items appear on this report. I had a person count the items on report and they stated "1809" which did not match item count in table. the report was not reporting some items due to a null field, in another table. I fixed the null entries, but want to ensure all the items are showing on this report.

The "OKC_MCC" table has 2618 entries, but 430 do not have "ID_NUMBER" field populated, so this report should contain 2188 entries.

 

[jackshield]

Sorry, I may not have been clear...

on this reports first column, "ID_NUMBER"

can I count how many items are generated?

 

[boblarson]

Sorry, I may not have been clear...

on this reports first column, "ID_NUMBER"

can I count how many items are generated?

Put a text box on the REPORT FOOTER (you can leave the footer's Visible property set to NO) and name it

txtIDCount

and in the control source put:
=Count([ID_NUMBER])

And then for the text box at the top of the report put the control source to be:
=[txtIDCount]

 

[jackshield]

Sorry, I may not have been clear...

on this reports first column, "ID_NUMBER"

can I count how many items are generated?

**edit**

maybe what I am asking is can I count the number of items generated by the "query" in this report?

I inherited this databse, and really dont have any access skills, but stuck with it until corporate issues their new tool, whenever that may be...

 

[jackshield]

Put a text box on the REPORT FOOTER (you can leave the footer's Visible property set to NO) and name it

txtIDCount

and in the control source put:
=Count([ID_NUMBER])

And then for the text box at the top of the report put the control source to be:
=[txtIDCount]

sorry to be such a pain:

do I name the box that, or the label for the box, it inserted both

 

[boblarson]

sorry to be such a pain:

do I name the box that, or the label for the box, it inserted both

Text box. The label is extraneous.

 

[jackshield]

sorry to be such a pain:

do I name the box that, or the label for the box, it inserted both

it reported date/time, i will try again

 

[jackshield]

it reported date/time, i will try again

sorry, i didnt get the name in
when i try to name it that, I get a box telling me there is already a control with that name

 

[jackshield]

sorry guy, hate eating up your time

the "page footer" has a control with this name, it is the one putting the date on the bottom of page, can i change the existing one to another name?

 

[jackshield]

i renamed one with date, it worked, but reports a number of "2788"

i think this report must be screwed?

 

[jackshield]

OK, when it counts the id_number field, it is counting a query?
i was able to bring up "SQL Statement : Query Builder" which had a record count of 2788, matching the info tallied in the report.
it reports the id_number in multiple lines depending on how many energy sources the item has, ie, 3 energy sources, 3 line entries.
Is there a way to tally the "ID_NUMBER", but exclude the duplicated entries?

 

[jackshield]

OK, when it counts the id_number field, it is counting a query?
i was able to bring up "SQL Statement : Query Builder" which had a record count of 2788, matching the info tallied in the report.
it reports the id_number in multiple lines depending on how many energy sources the item has, ie, 3 energy sources, 3 line entries.
Is there a way to tally the "ID_NUMBER", but exclude the duplicated entries?

can it be done by adding some kind of modifier to the count function?

i tried (*)=1 and select distinct, but cant seem to get the order/syntax right.

 

[boblarson]

can it be done by adding some kind of modifier to the count function?

i tried (*)=1 and select distinct, but cant seem to get the order/syntax right.

If you use the same query that the report uses as its record source, you can use that instead of the table name in the DCount. But, if duplicates are there and you don't want to count them, you would need to create another query off of that one for the report and only select the ID's and either use Grouping or Select DISTINCT.

 

[jackshield]

If you use the same query that the report uses as its record source, you can use that instead of the table name in the DCount. But, if duplicates are there and you don't want to count them, you would need to create another query off of that one for the report and only select the ID's and either use Grouping or Select DISTINCT.

i was hoping you wouldnt say that. my limited skills were trying to add something simple to an existing database. i think i am in over my head.

i need to verify what is actually showing up on the report to ensure they are all accounted for.