Count operator leads to parameter value error

[Neuro]

Why do I get a parameter value error if I try to operate on a field that has
total: Count? It's never been any trouble if it's total: Group By. For
instance if I have a query that is:

Field: Current Cage
Table: Mouse InfoTbl
Total: Group By

Field: Mouse ID
Table: Mouse InfoTbl
Total: Count

Field: [CountOfMouse ID]
Table:
Total: Group By

The 3rd column prints accurate when the query is run, but it is preceded by
a paramter value error that I can bypass by hitting 'ok' a couple of times.
If the database it to run smoothly, I need to for the error to go away.

Thanks for you advice.

 

[KARL DEWEY]

Try it this way --
Field: Current Cage
Table: Mouse InfoTbl
Total: Group By

Field: Mouse ID
Table: Mouse InfoTbl
Total: Count

Field: [Mouse ID]
Table: Mouse InfoTbl
Total: Count

 

[Neuro]

In simplifying my example for the post, my problem wasn't clear. My issue is
that I want to "count" how many mice are listed as being in a cage and how
many of these these mice have been retired. In order to know how many active
mice are in each cage, I am doing the following:

Field: Current Cage
Table: Mouse InfoTbl
Total: Group By

Field: Mouse ID
Table: Mouse InfoTbl
Total: Count

Field: Retire Date
Table: Mouse InfoTbl
Total: Count

Field: Total: [CountOfMouse ID]-[CountOfRetire Date].
Table:
Total: Group By

I get the parameter error message for both CountOfMouseID and CountOfRetire
Date]. After accepting the error message, the calculation works. What can I
do differently to make these error message stop showing up for this?

Thanks.


Total: [CountOfMouse ID]-[CountOfRetired]. The 'CountOf' part is
something that access automatically seems to append when the count operate is
used...

Try it this way --
Field: Current Cage
Table: Mouse InfoTbl
Total: Group By

Field: Mouse ID
Table: Mouse InfoTbl
Total: Count

Field: [Mouse ID]
Table: Mouse InfoTbl
Total: Count

--
Build a little, test a little.

Why do I get a parameter value error if I try to operate on a field that has
total: Count? It's never been any trouble if it's total: Group By. For
instance if I have a query that is:

Field: Current Cage
Table: Mouse InfoTbl
Total: Group By

Field: Mouse ID
Table: Mouse InfoTbl
Total: Count

Field: [CountOfMouse ID]
Table:
Total: Group By

The 3rd column prints accurate when the query is run, but it is preceded by
a paramter value error that I can bypass by hitting 'ok' a couple of times.
If the database it to run smoothly, I need to for the error to go away.

Thanks for you advice.

 

[Neuro]

Resolution:
:

Field: Total: [CountOfMouse ID]-[CountOfRetire Date].
Table:
Total: Group By THIS IS WRONG. SHOULD BE... Total: Expression

In simplifying my example for the post, my problem wasn't clear. My issue is
that I want to "count" how many mice are listed as being in a cage and how
many of these these mice have been retired. In order to know how many active
mice are in each cage, I am doing the following:

Field: Current Cage
Table: Mouse InfoTbl
Total: Group By

Field: Mouse ID
Table: Mouse InfoTbl
Total: Count

Field: Retire Date
Table: Mouse InfoTbl
Total: Count

Field: Total: [CountOfMouse ID]-[CountOfRetire Date].
Table:
Total: Group By

I get the parameter error message for both CountOfMouseID and CountOfRetire
Date]. After accepting the error message, the calculation works. What can I
do differently to make these error message stop showing up for this?

Thanks.


Total: [CountOfMouse ID]-[CountOfRetired]. The 'CountOf' part is
something that access automatically seems to append when the count operate is
used...

Try it this way --
Field: Current Cage
Table: Mouse InfoTbl
Total: Group By

Field: Mouse ID
Table: Mouse InfoTbl
Total: Count

Field: [Mouse ID]
Table: Mouse InfoTbl
Total: Count

--
Build a little, test a little.

Why do I get a parameter value error if I try to operate on a field that has
total: Count? It's never been any trouble if it's total: Group By. For
instance if I have a query that is:

Field: Current Cage
Table: Mouse InfoTbl
Total: Group By

Field: Mouse ID
Table: Mouse InfoTbl
Total: Count

Field: [CountOfMouse ID]
Table:
Total: Group By

The 3rd column prints accurate when the query is run, but it is preceded by
a paramter value error that I can bypass by hitting 'ok' a couple of times.
If the database it to run smoothly, I need to for the error to go away.

Thanks for you advice.