Re: Show Nulls in a table

Tech-Archive recommends: Speed Up your PC by fixing your registry

Not really. You could do it in your table, query, or report by using the Nz
function...


Nz([Somefieldname],"<NULL>")

--
Rick B



"sweetlisa1217 via AccessMonster.com" <u14343@uwe> wrote in message
news:56843f6105ed3@xxxxxx
> Is there a way to have nulls appear in a table, for example like in SQL
> the
> field value shows as <NULL> ?
>
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200510/1


.

Relevant Pages

  • Re: Is it possible to get a report where every column is sorted the way I want i
    ... Rick B, ... for both "test scores" and "quiz scores" at the same ... a new report every time I sort by a different column if I ... wanted a hard copy of the query. ...
    (microsoft.public.access.queries)
  • Re: Access
    ... Create a Query to determine which of the Records in the new Table are ... not already in the Permanent Table ... "Rick B" wrote: ... when you run the report you have two options. ...
    (microsoft.public.access.gettingstarted)
  • Re: Sorting multiple fields
    ... Many thaks Rick for your speedy and very helpful reply. ... I have just created a report using your suggestion and it ... as a result of a query. ... >I used the 'Build Event' to create a query that sorts ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Report Queries
    ... Rick, where do I need to put the expressions? ... inventorynumber portion under that field and the same for the location field? ... > Sounds like you could do it in one QUERY. ... I want to use the same fields in a report ...
    (microsoft.public.access.reports)
  • Re: Report Parameters
    ... In your query, don't ask the user to enter the date by entering ... the prompt, instead, refer to the field you stored your date in on the form. ... > Thanks for the quick reply Rick ... > and then pass it to the Report as a parameter ...
    (microsoft.public.access.reports)