Search results

  1. S

    NZ function

    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...
  2. S

    Default Values Disappear

    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)...
  3. S

    drop down writing to look up table

    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...
Top Bottom