sonnierock
Registered User.
- Local time
- Today, 22:32
- Joined
- Aug 6, 2002
- Messages
- 11
I got this problem
Name | Time1 | Time2 | Time3 | Time4 | Min Time|
==========================================
Tom | 12:13 | 07:00 | 17:00 | | 07:00 |
==========================================
Min Time is the Query result I need to get.
I know to Group by and sort them by Min if the time is in
the same column but when they are in diffrent column and
one of them is a null...........crazy
Then I wrote iif([time4] is null,.....,.....) and after
having program everthing Access say "The string return by
builder was too long. Message is truncated.
Thanks for your help,
Name | Time1 | Time2 | Time3 | Time4 | Min Time|
==========================================
Tom | 12:13 | 07:00 | 17:00 | | 07:00 |
==========================================
Min Time is the Query result I need to get.
I know to Group by and sort them by Min if the time is in
the same column but when they are in diffrent column and
one of them is a null...........crazy
Then I wrote iif([time4] is null,.....,.....) and after
having program everthing Access say "The string return by
builder was too long. Message is truncated.
Thanks for your help,