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
:
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
:
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
:
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.
