Counting posts

I need to count lines/posts in i a report.

The report shows dates or "no dates" (empty fields).

I need a "Total-line" in the bottom of the report, which shows how many
times a date is shown in a column in the report.

I need this for two colums in the report.

Put a textbox in the report footer. You will have to drag the report footer
down a little to have room. Make the control source of the textbox
=sum([dates])
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

I need to count lines/posts in i a report.

The report shows dates or "no dates" (empty fields).

I need a "Total-line" in the bottom of the report, which shows how many
times a date is shown in a column in the report.

I need this for two colums in the report.

Yes that seems to work, but I have two colums i need to count for dates.
Sometimes there can be 16 lines with dates in one column, and only 3 in the
column next to.
How can I solve that?


golfinray skrev:

Put a textbox in the report footer. You will have to drag the report footer
down a little to have room. Make the control source of the textbox
=sum([dates])
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

I need to count lines/posts in i a report.

The report shows dates or "no dates" (empty fields).

I need a "Total-line" in the bottom of the report, which shows how many
times a date is shown in a column in the report.

I need this for two colums in the report.

You would need a textbox to count each field.
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

Yes that seems to work, but I have two colums i need to count for dates.
Sometimes there can be 16 lines with dates in one column, and only 3 in the
column next to.
How can I solve that?


golfinray skrev:

Put a textbox in the report footer. You will have to drag the report footer
down a little to have room. Make the control source of the textbox
=sum([dates])
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

I need to count lines/posts in i a report.

The report shows dates or "no dates" (empty fields).

I need a "Total-line" in the bottom of the report, which shows how many
times a date is shown in a column in the report.

I need this for two colums in the report.

Yes, I have made two textboxes, one under each column I want to count, but
they show the same number of date-entries, even though it is 16 dates in the
first column and 3 dates (13 empty fields) in the other.

golfinray skrev:

You would need a textbox to count each field.
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

Yes that seems to work, but I have two colums i need to count for dates.
Sometimes there can be 16 lines with dates in one column, and only 3 in the
column next to.
How can I solve that?


golfinray skrev:

Put a textbox in the report footer. You will have to drag the report footer
down a little to have room. Make the control source of the textbox
=sum([dates])
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

I need to count lines/posts in i a report.

The report shows dates or "no dates" (empty fields).

I need a "Total-line" in the bottom of the report, which shows how many
times a date is shown in a column in the report.

I need this for two colums in the report.

As the control source, do =count([dates])
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

Yes, I have made two textboxes, one under each column I want to count, but
they show the same number of date-entries, even though it is 16 dates in the
first column and 3 dates (13 empty fields) in the other.

golfinray skrev:

You would need a textbox to count each field.
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

Yes that seems to work, but I have two colums i need to count for dates.
Sometimes there can be 16 lines with dates in one column, and only 3 in the
column next to.
How can I solve that?


golfinray skrev:

Put a textbox in the report footer. You will have to drag the report footer
down a little to have room. Make the control source of the textbox
=sum([dates])
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

I need to count lines/posts in i a report.

The report shows dates or "no dates" (empty fields).

I need a "Total-line" in the bottom of the report, which shows how many
times a date is shown in a column in the report.

I need this for two colums in the report.

Thank you for answering me, I have almost solved my problem.
But I cant find a way to count only fields with dates in two columns. I do
not want to count empty fields, which I do when I do like you say.

I guess I have to "link" the one textbox to the one column, and the other
textbox to the other column.

Then if I succed, I need to find a way to compare the two results of
counting.

If the counting says 10 dates in the one column, and 5 in the other, I will
show it as 50%.

Is that possible to do?


(Please forgive for the difficult way I try to explain this, but I do not
speak english normally :-))

golfinray skrev:

As the control source, do =count([dates])
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

Yes, I have made two textboxes, one under each column I want to count, but
they show the same number of date-entries, even though it is 16 dates in the
first column and 3 dates (13 empty fields) in the other.

golfinray skrev:

You would need a textbox to count each field.
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

Yes that seems to work, but I have two colums i need to count for dates.
Sometimes there can be 16 lines with dates in one column, and only 3 in the
column next to.
How can I solve that?


golfinray skrev:

Put a textbox in the report footer. You will have to drag the report footer
down a little to have room. Make the control source of the textbox
=sum([dates])
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

I need to count lines/posts in i a report.

The report shows dates or "no dates" (empty fields).

I need a "Total-line" in the bottom of the report, which shows how many
times a date is shown in a column in the report.

I need this for two colums in the report.

The name of your textbox (like textbox 1) divided by the second.
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

Thank you for answering me, I have almost solved my problem.
But I cant find a way to count only fields with dates in two columns. I do
not want to count empty fields, which I do when I do like you say.

I guess I have to "link" the one textbox to the one column, and the other
textbox to the other column.

Then if I succed, I need to find a way to compare the two results of
counting.

If the counting says 10 dates in the one column, and 5 in the other, I will
show it as 50%.

Is that possible to do?


(Please forgive for the difficult way I try to explain this, but I do not
speak english normally :-))

golfinray skrev:

As the control source, do =count([dates])
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

Yes, I have made two textboxes, one under each column I want to count, but
they show the same number of date-entries, even though it is 16 dates in the
first column and 3 dates (13 empty fields) in the other.

golfinray skrev:

You would need a textbox to count each field.
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

Yes that seems to work, but I have two colums i need to count for dates.
Sometimes there can be 16 lines with dates in one column, and only 3 in the
column next to.
How can I solve that?


golfinray skrev:

Put a textbox in the report footer. You will have to drag the report footer
down a little to have room. Make the control source of the textbox
=sum([dates])
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

I need to count lines/posts in i a report.

The report shows dates or "no dates" (empty fields).

I need a "Total-line" in the bottom of the report, which shows how many
times a date is shown in a column in the report.

I need this for two colums in the report.

I succeded with the last you wrote.

But how do I get the textbox to NOT count empty fields?

golfinray skrev:

The name of your textbox (like textbox 1) divided by the second.
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

Thank you for answering me, I have almost solved my problem.
But I cant find a way to count only fields with dates in two columns. I do
not want to count empty fields, which I do when I do like you say.

I guess I have to "link" the one textbox to the one column, and the other
textbox to the other column.

Then if I succed, I need to find a way to compare the two results of
counting.

If the counting says 10 dates in the one column, and 5 in the other, I will
show it as 50%.

Is that possible to do?


(Please forgive for the difficult way I try to explain this, but I do not
speak english normally :-))

golfinray skrev:

As the control source, do =count([dates])
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

Yes, I have made two textboxes, one under each column I want to count, but
they show the same number of date-entries, even though it is 16 dates in the
first column and 3 dates (13 empty fields) in the other.

golfinray skrev:

You would need a textbox to count each field.
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

Yes that seems to work, but I have two colums i need to count for dates.
Sometimes there can be 16 lines with dates in one column, and only 3 in the
column next to.
How can I solve that?


golfinray skrev:

Put a textbox in the report footer. You will have to drag the report footer
down a little to have room. Make the control source of the textbox
=sum([dates])
--
Milton Purdy
ACCESS
State of Arkansas


"Twisty" wrote:

I need to count lines/posts in i a report.

The report shows dates or "no dates" (empty fields).

I need a "Total-line" in the bottom of the report, which shows how many
times a date is shown in a column in the report.

I need this for two colums in the report.