Datetimestamp ==> Sequence number

  • Thread starter Thread starter shiro
  • Start date Start date
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.
 
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
 
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...
 
Back
Top