How do i create blank enty in numeric field

[scott munkirs]

Hi again

I have a field in query that is numeric. It calculates hours worke
for a day for hourly workers. I have one employee who is salary

How do I make my query show a BLANK in the field if the employee i
salary not hourly? The reason is that I will then use this query an
the field in a report. I would like the report to show the hour
worked for hourly employees and nothing (blank) for my salar
employee..

I wrote the iif statment as followed: =iif([pay type]=1," ", then th
rest of the formula..... My problem arises because I am tying to pu
a TEXT item (the space) into a numeric field...

Thanks

Scot

 

[MGFoster]

Hi again,

I have a field in query that is numeric. It calculates hours worked
for a day for hourly workers. I have one employee who is salary.

How do I make my query show a BLANK in the field if the employee is
salary not hourly? The reason is that I will then use this query and
the field in a report. I would like the report to show the hours
worked for hourly employees and nothing (blank) for my salary
employee...

I wrote the iif statment as followed: =iif([pay type]=1," ", then the
rest of the formula..... My problem arises because I am tying to put
a TEXT item (the space) into a numeric field...

Use NULL instead of a space:

IIf([pay type]=1,NULL,<false expression>)

 

[KARL DEWEY]

Use --
=iif([pay type]=1, Null, ......