I am trying to count all values in a table, but when I do it leaves out any that have no values yet or are null. I believe that the Count Method in Access doesn't allow the count of null values but is there a way to make the Count Method include nulls that I can just throw into the Criteria or something like that? if not how would I go about having the Count Method display those nulls? I am using the Count() function in SQL with Access 2003.
That helps but I am using Access 2003 and I have a table lets call it Items.
In this table I got numbers and Lines like so:
These numbers have lines in another column like so:
Column 1 Column 2
The number 1651 exists but it doesn't show up with Count because it doesn't show anything. What's the best way to go about solving this type of problem? Since I run a query it shows the numbers 1650, 1652, and 1653 but no 1651.