Problem comparing dates in If sentence

[Inkognito]

Ah, I see

I have now tested the script and counted the outputs, and it's counting and comparing correctly.

I left the Date field from the table the way it was, and changed the user inputs to US format with DateSerial

Finally, it seems there are no more errors.

Thx a lot guys

As you might have understood, I don't know access or visual basic at all, I just took a job for a firm to create a database just for fun so I have basically googled and forumed my way through it all, and it turned out great

 

[namliam]

Urm, but if you ask help... and someone tells you something...
It may be smart to read, think, read again, thing, read a third time, work it, start posting a reply, read it again, finish your reply, read it, double check your work, read it, then post...

I have had to repeat myself a *few* times which is IMHO not funny!

 

[Inkognito]

Yeah, i know, sorry. I was getting so confused, as I really believed I had gotten it to work without US format or CDate or DateSerial, and that you might have misunderstood the structure of my base, but that, of course, wasn't quite the case
In one moment the database seemed to work perfectly and I thought I were finished, and then in the next moment it didn't work at all

 

[namliam]

That is the beauty of implicit things... computers thinking for you... sometimes they work... sometimes they dont....