record counts

[axism]

Hi, I am trying to put # the of records return by a query on page header. I have a query that returns all people in one department as records source for report. how do I put a count of how many records are actually return with my query on top of page? I have a text box on top, just don't know what to put for control souce, please help. Thank you.

 

[Zonie32]

you could try control source = 1, running sum = Over All.

Or you could put in control source =Count([FieldName])

 

[dhookom]

Add a text box to your report header section:
Name: txtCountAll
Control Source: =Count(*)
Visible: No
Add a text box to the Page Header
Control Source: =txtCountAll

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[axism]

Thanks for replying zonie32 and dhookom. I just tried what you guys sugguested. zonie32, if i have control source = 1, running sum = over all, the text box will display #Error. If control source = count([fieldname]), txtbox will be blank. As for dhookom's method, I am getting #Error when previewing report as well. what did i do wrong hmm? any other sugguestion?

 

[dhookom]

axism,
Did you place the first text box in the report header section or in the page header?

I think a running sum is overkill for this.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]