Recent content by indy1982

Hi JANR, The answer below posted on 02-02-2012 03:09 PM is great and works fine. Is it possible now to work out the number of Business Days between Value_Date and Entry_Date and have the answer populate another column? Apologies for the cross-posting I am quite new to these forums...

Hi JR, Thanks for this, I have basic knowledge of Access. How can I use the function you have given me below to update both Entry_Date and Value_Date columns without creating new columns. So 20020322 would show as 22/03/2002 in date format for all fields in the Entry_Date column for...

Hi All, I have two columns in Access, Entry_Date & Value_Date. When I import this data into Access via a text file it is recognised as a number format ie 20020322. I want to show this as date format in the easiest possible way. I want to be able to show both these columns as date format ie...