View original (French)

Access Do not display a null value

AccessDebutant -  
 Ericka -
Hello,

I don't know much about Access and I have a little problem. I have a table labeled CompProf. This table contains five fields: NoAuto, NoCat, Cat, SSCat, and Titre.
I'm trying to produce a report based on this table; unfortunately, in the SSCat field, I have empty fields, which leaves me with blank rows in my report.
For example:
1 Cat(a)
SSCat (a)
Title aa
Title ab
2 Cat (b)

Title ba
Title bb
I know there’s a way to avoid leaving this blank line, but I forgot.

1 answer

  1. Ericka
     
    Hello,
    to avoid displaying the rows where there is nothing, you need to make a query in which you include all your fields and in the one where there are empty values you apply the criterion: is not null
    I don't know if I'm answering your question correctly?
    2