P
PA
Dear All,
I have query1 as follows:
Date Client Qty Time
01-Mar A 10 745
02-Mar A 20 945
05-Mar B 25 1215
08-Mar C 30 1345
01-Mar B 35 1535
02-Mar C 40 1935
05-Mar B 15 2125
I want to add 1 new field called Time_up_to (next to column Time) to this
query1 by using iif as has result as follow:
Date Client Qty Time Time_up_to
01-Mar A 10 745 800
02-Mar A 20 945 1000
05-Mar B 25 1215 1230
08-Mar C 30 1345 1400
01-Mar B 35 1535 1600
02-Mar C 40 1935 2000
05-Mar B 15 2125 2200
...............
................
.........
1000 more records..
To get result for field "Time_up_to", I may need to use IIF nested function
more than 10(if possible in access 2003?) , is there anyway I can make it
simple ?
Appreciate your advise.
Thanks alot,
PA
I have query1 as follows:
Date Client Qty Time
01-Mar A 10 745
02-Mar A 20 945
05-Mar B 25 1215
08-Mar C 30 1345
01-Mar B 35 1535
02-Mar C 40 1935
05-Mar B 15 2125
I want to add 1 new field called Time_up_to (next to column Time) to this
query1 by using iif as has result as follow:
Date Client Qty Time Time_up_to
01-Mar A 10 745 800
02-Mar A 20 945 1000
05-Mar B 25 1215 1230
08-Mar C 30 1345 1400
01-Mar B 35 1535 1600
02-Mar C 40 1935 2000
05-Mar B 15 2125 2200
...............
................
.........
1000 more records..
To get result for field "Time_up_to", I may need to use IIF nested function
more than 10(if possible in access 2003?) , is there anyway I can make it
simple ?
Appreciate your advise.
Thanks alot,
PA