I appreciated all of the responses.

Thank you.:-)

Jeff,

I missed your post. Very nice.:cool:

I came across the following article:

MS Access can retrieve and measure time with millisecond precision, but only with the help of a few well-known API calls and several user-defined functions.

http://www.devx.com/dbzone/Article/39046/1954

I...

dcw8888 (12/2/2011)

---

The data type in Access is "Date/Time". Yes, at first I thought Access does not store the milliseconds information as well because when I open the table up...

Thank you for your responses.:-)

I tried the join but I had to kill after 20 minutes with no result.

So I had to create dynamic SQL to include the Account Numbers...

@michael-2 Pretty slick script!:cool:

Thanks for posting.:-)

dcw8888 (12/2/2011)

---

The data type in Access is "Date/Time". Yes, at first I thought Access does not store the milliseconds information as well because when I open the table up...

What is the Date Format of the column in Microsoft Access.

Access 2007 does not store milliseconds and I was not aware that Access 2003 did either.

http://office.microsoft.com/en-us/access-help/format-date-and-time-values-HP001099015.aspx%5B\url]

Hi Phil,

What I found was that if you double click on the task and try to set the...

I did not set anything to Read_Only.

What do I check and what needs to be changed?:unsure:

Thanks.

@Gianluca Thanks!:-)

GSquared,

Thanks, you are correct, the Temp Table was out of scope.

I was attempting to reference the Temp Table outside a cursor. I had not created a Stored Procedure yet and...

Thanks GSquared.:-)

Thanks Lowell. 😎

Someone said that I could the...