I have a report that is connected to the query (below). I want a number to show on the report, but if it is null it is blank, so I want a null to show as 0. Here is my SQL:
SELECT Nz([CountOfStatID],0)+0 AS NP...
In Access 2010 I have a Data Entry Form on which I have an unbound textbox in the header that the user can put a default date in. In the body of the form is a bound textbox that records the date and the default value is set as =defaultdatestat (obviously the name of the box in the header)...
Looking for help!!
I have built a couple of databases, but now am trying to "normalize" and not use the lookup field in my tables.
I created a form based on a query. I added a drop down list to it so that field can be edited. However, when that field is chosen, it writes to the lookup table...