Datetimestamp ==> Sequence number

S

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.
 
R

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
 
S

shiro

Many Thank's Rob,
Works perfect.


Rob Parker said:
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
Click to expand...
 
Top