how do i enter a null value?

[burton]

Me and my teacher figured out a way of calculating number of hours from hours worked. but when i try to calculate all hours worked it doesn't add up because i have got null values.

my qry.

employee id
max hours a week (what they want to work)
monday start
monday finish
monday total (monday total([monday finish]-[monday start])*24)

and then it goes on upto saturday

then its got total hours worked.

but not every one works everyday.

the qry doesn't add up values that aren't there.

e.g

employee ID
1
monday start
08:00
monday finish
14:00
monday total
6
Tuesday Start

tuesday finish

tuesday total
0

and then

total hours a week
0

 

[Rich]

Try the Nz function, there have been numerous examples of its use posted here if you need them

 

[burton]

ok im really stuck now.

i have found out about this nz function from the access help. it says something about Nz(varX).
where do i enter this then?

do i create a new field in my qry?

please help.

if possible could you tell me how

 

[DJN]

No, just add the nz function to the field in the query that does the totalling. e.g. TotalHrs: NZ([TotalMonday])+NZ([TotalTuesday])

David