using "count" on a calculated field

[Pierkes]

Hi,
On a report i have a calculated field called "monthyear";

=month([tr_lastmod_date])&"-"&year([tr_lastmod_date])

It gives back something like "4-2014"

Now, i would like to know how many records i have in the database with "monthyear"

I tried counting the calculated field "mothyear" but when i run the report it will ask me a value for the field "monthyear" so it does not work.

Any idea on how to calculate on a calculated field ?

Thanks in advance,
Pierre

[Rabbit]

Group it by the expression.

[jimatqsi]

Pierre,
Your question is not very clear. You say,
"Now, i would like to know how many records i have in the database with 'monthyear'".
Do you mean as part of the report or you need that information independent of the report?

Without knowing anything about the organization or content of your report it's hard to say much helpful. As Rabbit says, you could group the report by that expression. Or you could change the underlying recordset/query to collect that information for you, which might be simpler.

More information could help us help you more.

Jim

[zmbd]

You also need to clear up where you are using this in:
A form textbox (which =month... might imply);
A VBA Code (which =month... also implies);
Or a Query (in which case =month... is not a proper syntax for a calculated field)