User Prompts and Count function

[sherrygroves]

Hi!



I am using several queries with Region Codes coded in the query. My reports are also based on the individual queries and has a Record count statement as well --
=DCount("[State]","Reporting Query1"). All is working fine.

Now to minimize the number of queries I need to write, I want to prompt for the Region code. I can do that [Enter Region Code:]. It prompts and the report shows the expected output (only records for that region code) BUT my count statement ceases to work and I get #Error instead of the number of records. This happens no matter which field I set to prompt.

[burrina]

Might be helpful to review this article. http://allenbrowne.com/RecordCountError.html

HTH

[June7]

Why use domain aggregate? Could you just do Sum(*) in textbox on report and get the correct count?

[sherrygroves]

I used the domain aggregate because it is the only count function I could get to work.

[June7]

Ooops, I mean Count(*)

[sherrygroves]

Can't get the Count(*) to work.

[June7]

What happens - wrong result, error?

If you want to provide db for analysis, follow instructions at bottom of my post.

[sherrygroves]

I figured it out and its working now. Thanks!!!

[June7]

Solved DCount(...) or Count(*)?

[sherrygroves]

I'm using Count(*). My problem was I had the Count text box in the page footer section instead of the report footer section. That is why none of the other count functions worked. My user prompts work as well. Thanks!!