Search results

I have two fields (start date/time) and (finish date/time), both of them have date and time values in them (as with the two example below) and they may be either text or dates which I import from excel. I can't really put them as date/time field type in access because it won't allow me, I...

It was a date and time in one field. I broke it up into separate date and separate time type. and I tried to use the finish time minus start time, but I couldn't do it, maybe because is text, so I convert it by using timevalue function.

SELECT timevalue([apt start time]), timevalue([apt finish time]), datediff("h", [apt finish time], [apt start time]) as difference FROM Fixing where [apt start date] = [apt finish date] and datediff("h", [apt finish time], [apt start time]) >= 6 I tried this and is still the same error as...

SELECT timevalue([apt start time]), timevalue([apt finish time]), cint(format(timevalue([apt finish time]) - timevalue([apt start time]), "h")) as difference FROM Fixing where [apt start date] = [apt finish date] and cint(format(timevalue([apt finish time]) - timevalue([apt start time]), "h"))...

Ok thanks boblarson. you are an expert, compare to how many post you have to mine. ;-)

Ok, thanks. IIf ( ([max upload date]=[apt start date] and [max upload time] >#8:00 pm#) , "LATE") AS D For some reason, I have an error with this, I don't know why?

with two or more conditions and have compare time. For example, IIf ( ([max upload date]-[apt start date])>=1,"LATE" ) AS B, but also add another logic to the first if IIf ( ([max upload date]=[apt...

Thanks, you guys are experts.

and find the max and min? How do you GROUP BY multiple fields and find the max and min of them? I did it and could only do it to one field, if I add more field I would have an error. Thanks, Appreciate it.