Recent content by SimoK

I want to select records over 2 days old, which is fine Tues-Fri but on Mon-Tues, so I want to check what day it is today first, to use that in the calculation. Clues please.

Thanks Tranman Have got the critical data out. Regards

Hello I am trying to create a database from a PDF file, I have converted it to txt but it has not done this cleanly, which means I cannot use the normal text import or I cut columns. Does anyone have any code where it looks for spaces and takes the characters to the next space to make the...

Thanks Norris, trying the split function, with try1: Split([Field1]," ",-1,-1) and get undefined function split in expression, but Access XP finds split when I do a help from the function box. Any clues?

Thanks Paul, think I can get it from this, what I am trying to do is to create a database from a pdf file, and while 99% of the fields line up every so often it throws up a line out of sync. If there are better ways to do it than look for spaces, don't hesitate to let me know

Have you tried descending instead of ascending order or vice versa?

I am trying to organise some data which is not in a fixed format, and can only do this by finding out what position/s spaces are to determine the end/start of fields, what does Access offer to do this and how please?