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 |
#11
|
|||
|
|||
How to count records using count(*) in a chart report
Looking at this question again, does your report even have a record source? I
expect it might not since the data is derived from the Row Source of the chart control. You may need to add a record source that return just the count. -- Duane Hookom Microsoft Access MVP "FL" wrote: Hi Daryl, I tried your suggestion on my date field and get #Error. I tried it in both page footer and report footer sections. Same results. -- FL "Daryl S" wrote: FL - You should be able to put = count([datefield]) in the footer of the report. If it is not working, what does it show? Maybe you just forgot the equal sign? -- Daryl S "FL" wrote: I tried to use the count(*) function in a text box in a chart report. I have page header and footer and added report header and footer. I tried to place the text box in each location with no luck. Nor will it work if I place it in the detail section of chart report. There are no fields showing when selecting grouping and sorting to create a group header or footer. However, my chart does plot data from two fields. One is a date field and the other is a number field that I'm trying to count the number of records when report is run. Any suggestions? -- FL |
#12
|
|||
|
|||
How to count records using count(*) in a chart report
Looking at this question again, does your report even have a record source? I
expect it might not since the data is derived from the Row Source of the chart control. You may need to add a record source that return just the count. -- Duane Hookom Microsoft Access MVP "FL" wrote: Hi Daryl, I tried your suggestion on my date field and get #Error. I tried it in both page footer and report footer sections. Same results. -- FL "Daryl S" wrote: FL - You should be able to put = count([datefield]) in the footer of the report. If it is not working, what does it show? Maybe you just forgot the equal sign? -- Daryl S "FL" wrote: I tried to use the count(*) function in a text box in a chart report. I have page header and footer and added report header and footer. I tried to place the text box in each location with no luck. Nor will it work if I place it in the detail section of chart report. There are no fields showing when selecting grouping and sorting to create a group header or footer. However, my chart does plot data from two fields. One is a date field and the other is a number field that I'm trying to count the number of records when report is run. Any suggestions? -- FL |
#13
|
|||
|
|||
How to count records using count(*) in a chart report
Looking at this question again, does your report even have a record source? I
expect it might not since the data is derived from the Row Source of the chart control. You may need to add a record source that return just the count. -- Duane Hookom Microsoft Access MVP "FL" wrote: Hi Daryl, I tried your suggestion on my date field and get #Error. I tried it in both page footer and report footer sections. Same results. -- FL "Daryl S" wrote: FL - You should be able to put = count([datefield]) in the footer of the report. If it is not working, what does it show? Maybe you just forgot the equal sign? -- Daryl S "FL" wrote: I tried to use the count(*) function in a text box in a chart report. I have page header and footer and added report header and footer. I tried to place the text box in each location with no luck. Nor will it work if I place it in the detail section of chart report. There are no fields showing when selecting grouping and sorting to create a group header or footer. However, my chart does plot data from two fields. One is a date field and the other is a number field that I'm trying to count the number of records when report is run. Any suggestions? -- FL |
#14
|
|||
|
|||
How to count records using count(*) in a chart report
Duane,
Thanks for getting back to me. Your absolutely right the chart report I created using the wizard does not have a record source. It's blank. I don't know why. I'm trying to add a record source that returns a count, as you suggest, but having difficulties in doing this so far. How do I create a count function within a query or SQL? Can this be from the same query the chart pulls data from? -- FL "Duane Hookom" wrote: Looking at this question again, does your report even have a record source? I expect it might not since the data is derived from the Row Source of the chart control. You may need to add a record source that return just the count. -- Duane Hookom Microsoft Access MVP "FL" wrote: Hi Daryl, I tried your suggestion on my date field and get #Error. I tried it in both page footer and report footer sections. Same results. -- FL "Daryl S" wrote: FL - You should be able to put = count([datefield]) in the footer of the report. If it is not working, what does it show? Maybe you just forgot the equal sign? -- Daryl S "FL" wrote: I tried to use the count(*) function in a text box in a chart report. I have page header and footer and added report header and footer. I tried to place the text box in each location with no luck. Nor will it work if I place it in the detail section of chart report. There are no fields showing when selecting grouping and sorting to create a group header or footer. However, my chart does plot data from two fields. One is a date field and the other is a number field that I'm trying to count the number of records when report is run. Any suggestions? -- FL |
#15
|
|||
|
|||
How to count records using count(*) in a chart report
Duane,
Thanks for getting back to me. Your absolutely right the chart report I created using the wizard does not have a record source. It's blank. I don't know why. I'm trying to add a record source that returns a count, as you suggest, but having difficulties in doing this so far. How do I create a count function within a query or SQL? Can this be from the same query the chart pulls data from? -- FL "Duane Hookom" wrote: Looking at this question again, does your report even have a record source? I expect it might not since the data is derived from the Row Source of the chart control. You may need to add a record source that return just the count. -- Duane Hookom Microsoft Access MVP "FL" wrote: Hi Daryl, I tried your suggestion on my date field and get #Error. I tried it in both page footer and report footer sections. Same results. -- FL "Daryl S" wrote: FL - You should be able to put = count([datefield]) in the footer of the report. If it is not working, what does it show? Maybe you just forgot the equal sign? -- Daryl S "FL" wrote: I tried to use the count(*) function in a text box in a chart report. I have page header and footer and added report header and footer. I tried to place the text box in each location with no luck. Nor will it work if I place it in the detail section of chart report. There are no fields showing when selecting grouping and sorting to create a group header or footer. However, my chart does plot data from two fields. One is a date field and the other is a number field that I'm trying to count the number of records when report is run. Any suggestions? -- FL |
#16
|
|||
|
|||
How to count records using count(*) in a chart report
Duane,
Thanks for getting back to me. Your absolutely right the chart report I created using the wizard does not have a record source. It's blank. I don't know why. I'm trying to add a record source that returns a count, as you suggest, but having difficulties in doing this so far. How do I create a count function within a query or SQL? Can this be from the same query the chart pulls data from? -- FL "Duane Hookom" wrote: Looking at this question again, does your report even have a record source? I expect it might not since the data is derived from the Row Source of the chart control. You may need to add a record source that return just the count. -- Duane Hookom Microsoft Access MVP "FL" wrote: Hi Daryl, I tried your suggestion on my date field and get #Error. I tried it in both page footer and report footer sections. Same results. -- FL "Daryl S" wrote: FL - You should be able to put = count([datefield]) in the footer of the report. If it is not working, what does it show? Maybe you just forgot the equal sign? -- Daryl S "FL" wrote: I tried to use the count(*) function in a text box in a chart report. I have page header and footer and added report header and footer. I tried to place the text box in each location with no luck. Nor will it work if I place it in the detail section of chart report. There are no fields showing when selecting grouping and sorting to create a group header or footer. However, my chart does plot data from two fields. One is a date field and the other is a number field that I'm trying to count the number of records when report is run. Any suggestions? -- FL |
#17
|
|||
|
|||
How to count records using count(*) in a chart report
I expect you want to count something that is based on the same data as your
chart. Provide the Row Source SQL view and tell us what you want to count. -- Duane Hookom Microsoft Access MVP "FL" wrote: Duane, Thanks for getting back to me. Your absolutely right the chart report I created using the wizard does not have a record source. It's blank. I don't know why. I'm trying to add a record source that returns a count, as you suggest, but having difficulties in doing this so far. How do I create a count function within a query or SQL? Can this be from the same query the chart pulls data from? -- FL "Duane Hookom" wrote: Looking at this question again, does your report even have a record source? I expect it might not since the data is derived from the Row Source of the chart control. You may need to add a record source that return just the count. -- Duane Hookom Microsoft Access MVP "FL" wrote: Hi Daryl, I tried your suggestion on my date field and get #Error. I tried it in both page footer and report footer sections. Same results. -- FL "Daryl S" wrote: FL - You should be able to put = count([datefield]) in the footer of the report. If it is not working, what does it show? Maybe you just forgot the equal sign? -- Daryl S "FL" wrote: I tried to use the count(*) function in a text box in a chart report. I have page header and footer and added report header and footer. I tried to place the text box in each location with no luck. Nor will it work if I place it in the detail section of chart report. There are no fields showing when selecting grouping and sorting to create a group header or footer. However, my chart does plot data from two fields. One is a date field and the other is a number field that I'm trying to count the number of records when report is run. Any suggestions? -- FL |
#18
|
|||
|
|||
How to count records using count(*) in a chart report
I expect you want to count something that is based on the same data as your
chart. Provide the Row Source SQL view and tell us what you want to count. -- Duane Hookom Microsoft Access MVP "FL" wrote: Duane, Thanks for getting back to me. Your absolutely right the chart report I created using the wizard does not have a record source. It's blank. I don't know why. I'm trying to add a record source that returns a count, as you suggest, but having difficulties in doing this so far. How do I create a count function within a query or SQL? Can this be from the same query the chart pulls data from? -- FL "Duane Hookom" wrote: Looking at this question again, does your report even have a record source? I expect it might not since the data is derived from the Row Source of the chart control. You may need to add a record source that return just the count. -- Duane Hookom Microsoft Access MVP "FL" wrote: Hi Daryl, I tried your suggestion on my date field and get #Error. I tried it in both page footer and report footer sections. Same results. -- FL "Daryl S" wrote: FL - You should be able to put = count([datefield]) in the footer of the report. If it is not working, what does it show? Maybe you just forgot the equal sign? -- Daryl S "FL" wrote: I tried to use the count(*) function in a text box in a chart report. I have page header and footer and added report header and footer. I tried to place the text box in each location with no luck. Nor will it work if I place it in the detail section of chart report. There are no fields showing when selecting grouping and sorting to create a group header or footer. However, my chart does plot data from two fields. One is a date field and the other is a number field that I'm trying to count the number of records when report is run. Any suggestions? -- FL |
#19
|
|||
|
|||
How to count records using count(*) in a chart report
I expect you want to count something that is based on the same data as your
chart. Provide the Row Source SQL view and tell us what you want to count. -- Duane Hookom Microsoft Access MVP "FL" wrote: Duane, Thanks for getting back to me. Your absolutely right the chart report I created using the wizard does not have a record source. It's blank. I don't know why. I'm trying to add a record source that returns a count, as you suggest, but having difficulties in doing this so far. How do I create a count function within a query or SQL? Can this be from the same query the chart pulls data from? -- FL "Duane Hookom" wrote: Looking at this question again, does your report even have a record source? I expect it might not since the data is derived from the Row Source of the chart control. You may need to add a record source that return just the count. -- Duane Hookom Microsoft Access MVP "FL" wrote: Hi Daryl, I tried your suggestion on my date field and get #Error. I tried it in both page footer and report footer sections. Same results. -- FL "Daryl S" wrote: FL - You should be able to put = count([datefield]) in the footer of the report. If it is not working, what does it show? Maybe you just forgot the equal sign? -- Daryl S "FL" wrote: I tried to use the count(*) function in a text box in a chart report. I have page header and footer and added report header and footer. I tried to place the text box in each location with no luck. Nor will it work if I place it in the detail section of chart report. There are no fields showing when selecting grouping and sorting to create a group header or footer. However, my chart does plot data from two fields. One is a date field and the other is a number field that I'm trying to count the number of records when report is run. Any suggestions? -- FL |
#20
|
|||
|
|||
How to count records using count(*) in a chart report
Thanks Duane - I learned something new today!
-- Daryl S "Duane Hookom" wrote: This will not work in the Page Footer. It will also not work if the name of the control is the name of a field in the record source of the report. -- Duane Hookom Microsoft Access MVP "FL" wrote: Hi Daryl, I tried your suggestion on my date field and get #Error. I tried it in both page footer and report footer sections. Same results. -- FL "Daryl S" wrote: FL - You should be able to put = count([datefield]) in the footer of the report. If it is not working, what does it show? Maybe you just forgot the equal sign? -- Daryl S "FL" wrote: I tried to use the count(*) function in a text box in a chart report. I have page header and footer and added report header and footer. I tried to place the text box in each location with no luck. Nor will it work if I place it in the detail section of chart report. There are no fields showing when selecting grouping and sorting to create a group header or footer. However, my chart does plot data from two fields. One is a date field and the other is a number field that I'm trying to count the number of records when report is run. Any suggestions? -- FL |
|
Thread Tools | |
Display Modes | |
|
|