How to make a query like this ?

[janwillem]

Hi,

I have a query with the following output:

date1 date2

1-1-2008
2-1-2008 1-3-2008
1-3-2008
3-1-2008
4-1-2008


Now i want to have an extra colum in this query that shows date1 when dat2
is not available, and shows date2 when date2 is available:

date1 date2 output:

1-1-2008 1-1-2008
2-1-2008 1-3-2008 1-3-2008
1-3-2008 1-3-2008
3-1-2008 3-1-2008
4-1-2008 4-1-2008



anyone knows how i can arange this?

thnx.

 

[Allen Browne]

Type an expression like this into the Field row in query design:
output: IIf([date2] Is Null, [date1], [date2])

 

[Dale Fye]

Or:

Output: NZ([Date2], [Date1])

HTH
Dale