How to make a query like this ?

  • Thread starter Thread starter janwillem
  • Start date Start date
J

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.
 
Type an expression like this into the Field row in query design:
output: IIf([date2] Is Null, [date1], [date2])
 
Back
Top