Recent content by ifjzettner

Both works, thank you very much guys.

Hello all, Thanks for opening my thread. I'm calculating total times in a query, based on the start time, the end time and the total time, which is simply end time minus start time. What I wish to achieve: if the minutes show 0-9, round down to the nearest hour. Else, round up to the nearest...

SOLVED. Solution is, must put the "-" separator between the year, month and day values. Thank you very much!

Here it is. I changed date format to yy.mm.dd in the code, and set short date in the EVENTS table, others are unchanged. I searched Google and it returned an article "Date comes out as Time after using DATE in VBA". Maybe there is useful stuff (can't post links yet).

Thanks for the tips. Tables emptied, own dates put in, no change. New database built for scratch, same procedure, no change. Computer internal clock set to dd.mm.yyyy, no change. In the table EventDayAndTime, the TheDate field is not recognized as a date. If I change the date into long date...

Hello JHB, Thank you very much for the detailed explanation. Could you please help me further? Without modifying anything, EventDayAndTime returned strange results for me. Without running the Query, in the original file I read normal short dates in the EventDateAndTime table. But when I run...

Hello all, Thanks for opening my thread. I build a database to manage some events. To simplify things, let's assume an event takes place on 3 days, from 01-05-2013 to 03-05-2013. I create a table named EVENTS. Among other stuff, I create the following fields: EVENT_first_date EVENT_last_date...

Hello Members, My name is Tamas, I live in Budapest, Hungary. I'm neither an experienced programmer, nor an IT expert. I build databases primarily for my company needs, namely to automatize some processes and to ease workload. I work in the motor sports industry. My databases usually work well...