Dato fejl i forespørgsel

Not easy to see when we cant see waht is in [LevTermin]. Make sure there is data in th efield or it will fail!

Dataene er i det felt. Eksempel på data:

200434 = år 2004 uge 34

Have you upgraded to a newer version of Access? Normally there is a good explanation when things happen "Lige pludselig"!


If I write this in the debug window I get aug (august) as the result.


?Format(CDate("01-01-" & Left("200434",4))+(Right("200434",2)-1)*7,"mmm")

So I think you must be 100% sure that data is actually in [LevTermin] and in ALL records. If only one record is wrong then the query will fail!

!!

Nu virker det... der var en post der ikke "så rigtig ud".

tak!