|Is there a specific requirement to use MS Access as your database? Access really should only be used by itself, if used at all.
SQL Server Developer/Express is free: SQL Server Downloads | Microsoft[^]
I know this does not answer your original question about zeros/nulls w/Crystal Reports, but I could not overlook an opportunity to "try" and convince someone not to use MS Access....for anything, ever.
My recommendation is to port over the general table schema and data from MS Access into an SQL Server database, then you are only stuck with the nightmare that is Crystal reports.
modified 6-Jul-21 7:16am.