Datetimestamp ==> Sequence number

[shiro]

Hi All,
I store a datetimestamp data in my table.
These record sort ascending in my report's query.
Then I set the format properties to # without decimal
places.
Unfortunately,it return me 39450,while I want it
become 1,2,3 and so on.

Is it possible tho change the datetimestamp become
the numbers start with 1 in my reports for the first record.

Thank's in advance.

 

[Rob Parker]

If you are wanting to number the records in your report sequentially (which
is what it seems to me that your trying to do), then you don't need to do
this. Just add an unbound textbox to your report, set its Control Source
to "=1", and set its Running Sum property to "Over All". Both these
properties are on the Data tab for the textbox control which you place in
the report.

HTH,

Rob

 

[shiro]

Many Thank's Rob,
Works perfect.

If you are wanting to number the records in your report sequentially (which
is what it seems to me that your trying to do), then you don't need to do
this. Just add an unbound textbox to your report, set its Control Source
to "=1", and set its Running Sum property to "Over All". Both these
properties are on the Data tab for the textbox control which you place in
the report.

HTH,

Rob