Type error in some calculations

[The1MegaByte]

Been using this DB for 15 years (that someone else created). Now this year it decides to give me errors. Every year I add a new table called Registrations, and change the name of the old Registrations by adding the year. Every year, I use the same report also called Registrations.

This year, when it generates the report, it gives me a Type error, one SOME of the calculations in the Report Footer. An example of a calculation is, ="Campers: " & [CamperCount]. I finally discovered what CamperCount is. It is a formula, in the Detail section of the report =If([ClubName.District]="51",1,0). There is a table called ClubName and there is a field called District.

[Welshgasman]

Check your data.
ClubName.District is likely Null in at least one record.

[The1MegaByte]

Check your data.
ClubName.District is likely Null in at least one record.

Thank you for your help.

Yes, ClubName.District was blank in one record.
However, I am still being asked to enter a value for ClubName.District.

[June7]

Shouldn't even be creating a new table each year. Should be one table with a field that allows filtering records by year.

Shouldn't really need table name in that expression unless same field name is used in various tables and those tables are in recordsource. Expression should also work if field is Null and return 0.

Is District field a number or text type? If number, don't use quote marks around 51.

[Welshgasman]

Upload the db with enough to see the issue AND instructions on how to recreate.
If you need to obscure the data, use this on a copy

[The1MegaByte]

Shouldn't even be creating a new table each year. Should be one table with a field that allows filtering records by year.

Well that's a good idea

Shouldn't really need table name in that expression unless same field name is used in various tables and those tables are in recordsource. Expression should also work if field is Null and return 0.

Is District field a number or text type? If number, don't use quote marks around 51.

District is ShortText

[The1MegaByte]

Upload the db with enough to see the issue AND instructions on how to recreate.
If you need to obscure the data, use this on a copy

I imported the forum into a copy of the DB. But it shows the someone else's Tables and Fields, (seems to be about court).

[Welshgasman]

You run that code against your dB. Follow the instructions.