Absolute record position

[peace77]

Hello friends,

I am looking for a code to pick up the date from the data set and store it in the field named as “asatdate”.

This required date always appears on the third record of the data set. Would anyone be able to suggest the code to pick up the date for this absolute position of third record.

This is how the first three record always show up as :

ABC LTD
Report: Summary
01/12/2007 To 31/12/2007

I need to pick up the third record which has the date specified on it.

Thanks for your help.

Peace

 

[fneily]

What? Are you talking about an Access table/query recordset? If so, then a record has fields and a field contains data with common characteristics. You would not have three records as described in your post.
Can you clarify?

 

[TheAceMan1]

How are ya peace77 . . .

[blue]This is how the first three record always show up as :

ABC LTD
Report: Summary
01/12/2007 To 31/12/2007[/blue]

Looks like [blue]Excel[/blue] to me! . . . [blue]You'll have to show how you got an Access table to format in this way![/blue] . . . To my knowledge (forcefully!) can;t be done . . .

[blue]Please explain how you got an Access table to do this?[/blue] . . . I await! . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[JoeAtWork]

ABC LTD
Report: Summary
01/12/2007 To 31/12/2007

What is this, a single string?

I think you will need to show us the code where you load that data. Where does it come from, a file, a database?

 

[peace77]

Sorry for inadequate info..I was asking for Access record set. Anyhowit was a simple one:



If RS.RecordCount > 0 Then
RS.MoveFirst
asatdate = Trim(Right(RS("AllData"), 24))



i have a complex code to bring over the data to access and then structuring the information...i realized that the dates were actually on the first record (not the third one as I had mentioned earlier) hence i have it as MoveFirst...it works well now..

thanks!