Error Message Calculating totals

[SaraMegan]

So there must be something I'm missing... I'm creating a report from a query, and in the page footer I want it to display the total of results from the query. I created a text box. For control source, I put =Count(*) and it comes back #Error... I got the equation from the help in Access, so I was pretty sure it would work, but it didn't .

Am I just missing something very basic here?

--Sara

 

[Sohaila Taravati]

You have to do this:
=Count([YourTextBox])
I hope this helps

 

[SaraMegan]

I tried that... See, some of the data in the fields his left blank, and the Access Help said that using the * wouldn't cause a problem if soem of the fields conatain a null value... So I tried using the *, and I tried using the field name of my primary key, which is in every record... I'm just not sure what's up.

--Sara

 

[Sohaila Taravati]

You can put Is Not Null in your query and just show the records that have values in them, then do what you where doing. That might help.