Thread: [Solved] Cleaning up a database
View Single Post
 
Old 08-09-2017, 12:34 PM
doctormathis doctormathis is offline Windows 10 Office 2016
Novice
 
Join Date: Aug 2017
Posts: 5
doctormathis is on a distinguished road
Default

Quote:
Originally Posted by NoSparks View Post
hello doc

I have no problem getting things to individual rows but am having issues getting the userid and dates due to inconsistencies of the data.

Why do the date formats differ ie: C2 and C5, is this normal ? How is the original data obtained ?
Do you have a list of all userid's that could be checked for ?
Will the userid always be at the start of the line when used ?

Yes, previously the current users had no set guidelines for inputs. I am thinking that if I group each section of issues like the one you noticed I will have to come up with an answer for each group.
Reply With Quote