Hello,

is it possible to do following table update with a querry ?

First part:

Table

Date Field ....
1.4.05 0
1.4.05 0
2.4.05 0
3.4.05 0
3.4.05 0
3.4.05 0

update to:

1.4.05 8
1.4.05 0
2.4.05 8
3.4.05 8
3.4.05 0
3.4.05 0

Basicaly there could be one or more records for a date, and I want to update
Field to one specific value (in upper example to 8), but only one record of
each day. It does not matter, if it is the first one or second one...

The second part:

How is it possible to insert missing days in the following table:

Table

Date Field
1.4.05 3424
3.4.05 3565
4.4.05 6235
7.4.05 3563
9.4.05 9096

and I want to get
1.4.05 3424
2.4.05 0
3.4.05 3565
4.4.05 6235
5.4.05 0
6.4.05 0
7.4.05 3563
8.4.05 0
9.4.05 9096


Regards,
Primoz