If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Counting posts
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. |
#3
|
|||
|
|||
Counting posts
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. |
#4
|
|||
|
|||
Counting posts
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. |
#5
|
|||
|
|||
Counting posts
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. |
#6
|
|||
|
|||
Counting posts
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. |
#7
|
|||
|
|||
Counting posts
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. |
#8
|
|||
|
|||
Counting posts
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. |
#9
|
|||
|
|||
Counting posts
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. |
Thread Tools | |
Display Modes | |
|
|