Search results

Hi, thanks for replying! The date is in the form of a 5digit number...i.e 365.04. I'll give those other codes a whirl. In the query do I choose the field with a date in and leave the next one blank and fill in the criteria with the code? sorry - bit of a newbie!

Hi, no this last entry is from a table that is put in manually via a form. Sue

Hi this is the code to convert a julian day to a date Function CJulian2Date(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 Function If JulDay > 0 And JulDay < 366 Or...

Hi, I need to display a field's last entry on a form so a user will know what the next entry needs to be. I know how to creat subforms but I wondered if there was a simpler way to do this? thanks Sue

Hi! Me again... I have a report that I would like to sort but via a form. I would like to put in a criteria and then just have those ones in the report? I know how to sort it by going into design and grouping etc. but I need to make an easier way to access this for other people who don't know...

Hi all! I need some help with a few calculations in my database, but please bear with me as I'm not too crash hot on how this all works. I have a field in a table with a julian day..i.e. 50.04 instead of 19th Feb 2004. I would like another field on the same table to plus 250 days to this...