UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> How To Bring The Dates In The Second Line To Start And End Date, Access 2016    
 
   
mantral
post Aug 27 2019, 05:16 PM
Post#1



Posts: 160
Joined: 30-January 10
From: So Cal


Good Afternoon Gurus,

Is there a way to populate the second line that contains dates i.e. "07/01/2019 thru 09/30/2019" to columns Start Date and End Date.

Document_ Number StudentName StudentID Course Name Status Start Date End Date
DOC20190702147 LEE, MICHAEL 25798 ENGLISH LITERATURE PASS ? "First Date Here" "Second Date Here"
07/01/2019 THRU 09/30/2019

DOC20190702147 JOHNSON, TAMY 56471 US HISTORY PASS ?
07/01/2019 THRU 09/30/2019

DOC20190702144 ANDERS, MATTHEW 87521 MATH 101 PASS ?
07/02/2019 THRU 09/30/2019

Any help is greatly appreciated.

Thank you,
Go to the top of the page
 
June7
post Aug 27 2019, 05:23 PM
Post#2



Posts: 967
Joined: 25-January 16



Is that how data is in table? Each "record" is two lines in table?

It is possible to parse a string to multiple parts but really need better explanation of data structure.


--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG! http://www.cpearson.com/Excel/DebuggingVBA.aspx
Go to the top of the page
 
mantral
post Aug 27 2019, 06:41 PM
Post#3



Posts: 160
Joined: 30-January 10
From: So Cal


Thank you for the quick reply.

Yes these are data from a table

Table columns are...
Document_Number, Student Name, StudentID, Course Name, Status, Start Date, End Date.

Below are two rows imported from Excel spreadsheet.
First Row of is Student identifier i.e. "Student Name, Course Name, etc.

I need to get the second row with the dates and put the dates in to Start Date and End Date.

Thank you,
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    17th November 2019 - 03:02 AM