check null on "Continuous Forms", change backcolour

  • Thread starter Thread starter OTWarrior via AccessMonster.com
  • Start date Start date
O

OTWarrior via AccessMonster.com

I have a form using a query that displays the count of the different types of
data inputted that month (so the form would normally look like this:)

type1 36
type2 23
type4 89

or

type1 78
type2 54
type3 23
type4 40

if there has been no work done for that type that month, the type will not
show (as it is a null value)

is there a way of checking for that null? I want to make the form a different
colour if there hasn't been any work done in that area.

Since there are no records that appear, is there a property for that (ie: row
count?)
 
OTWarrior said:
I have a form using a query that displays the count of the different types of
data inputted that month (so the form would normally look like this:)

type1 36
type2 23
type4 89

or

type1 78
type2 54
type3 23
type4 40

if there has been no work done for that type that month, the type will not
show (as it is a null value)

is there a way of checking for that null? I want to make the form a different
colour if there hasn't been any work done in that area.

Since there are no records that appear, is there a property for that (ie: row
count?)
Click to expand...


The records with Null are not appearing because they are
not in the form's record source query. Forget the form for
now and work on the query.

I can't ne sure without seeing it, but I suspect that all
you need to so is change the query to use an outer join
insteaf of inner join.
 
Back
Top