Search results

Roger that. Cool. I had to go in and make sure our julian dates went to 5 digits instead of 4 like we used to use. Took a little while, but the query is working now. Thank you all for the help. We will just need to change how we input our julian dates, but i'd rather make that minor change...

Alright I found the information you were looking for in the modules. Here is whats in there: Function CJulianToDate(JulDay As Integer, Optional YYYY) If IsMissing(YYYY) Then YYYY = Year(Date) If Not IsNumeric(YYYY) Or YYYY \ 1 <> YYYY Or YYYY < 100 Or YYYY > 9999 Then Exit...

Also, we use all the data and output it to kml files for Google Earth. This is what I just noticed. I changed the criteria from ">CDatetoJulian(Date())" to just say "<7000" which would basically make all the julian dates 0001, 0002, 0003, etc show up. When I load that into Google Earth, the...

I agree, but if I did that, I would have to go through and changed thousands of records along with changing over 50 different tables.

I'd love to post that function if i knew where to find it haha. I just assumed it was something built into Access. I know the people that originally created this used a lot of SQL with it so I'm assuming there is somewhere with a lot of code that might have that function? I'll look around.

Hey all. I'm not an expert with Access 2003, but am learning more everyday. With my job, we track a lot of stuff using Microsoft Access 2003 and have had some issues since January 1, 2010. Unfortunately, the people that created our database are long gone and I've had to try to figure things...