Search results

nope - it passes over 24 hours but it's a mess with the minutes, the calculation isnt right. Something to do with the fact that I use the french version of windows and office?

just found out - in the format thing..AND IT WORKS send you the beer again, give me u're adress

I know that isn't good for your mood, but how do I specify in my form field where the result of the query is delivered that it shoud call this function? :D

I'll try it now Thank you Sir

Pat, it worked now, it had problems yesterday I suppose The thing is I knex that link already, and I can't yet handle to manage it. Just one simple question: in access 2002 there is no other way to get as a result of a query a record like 35:45, without having to pass by code? Is no way that in...

after I wrote that I saw that the link is not working searching after right now :-)

Thank you Pat

I have this query : SELECT Sum((Planning.TotalHeures)) AS SommeDeTotalHeures FROM Planning WHERE (((Planning.[Nom Agent])=Forms!Plan.Texte5)); It should give me results like 35hours 45 minutes, but when it's passing over 24 hours is someting like 1,3355--etc How can I use the format in the...

actualy the subject should be conversion hours, sorry for inconvenience

Howdy Now is that : I have a query that looks like this : SELECT (Sum(Planning.TotalHeures)) FROM Planning WHERE (((Planning.[Nom Agent])=Forms!Plan.Texte5)); The thing is I have the time in hours in the field TotalHeures and the result of the query is something like 1.653333 for example. So...

I knew it's something like this. It worked. Now I will try to write it down myself in order to be able to do it right. Thank you Sir.

Howdy I know it should be easy this one but I am still not able to do it. So: In a table where I have name and date (both are not unique), I want to do a query to tell me if for one client I have two times the same date. How it should look this query? Thank you

Yes, I found some good answers. I got trapped now in a conversion issue. Some total hours that I get from a query like 1.33etcetc instead of 27:30 or something. Can I put a criteria in the query to convert in the right format? I found some related topics on the forum but I still can't do it right

well, I find great and very hippie to help the others without any material (obvious) reason. it's kind of rare in the real world. So it's still amaizin' for me :-) nice day

Idjit, it was like a joke. I might be a newbie in access but I didn't discover the internet yesterday :-) Quand meme I'm 30

That was what I needed Thank you a lot for your time man it's really good this internet thing :)

I've opened the database that you sent, thanks again It's only that the query creates columns, and I need in my case to create records...I think it was me not telling this in the right way :D Actualy I would enjoy those beautiful 6 dates that your query creates to be vertical, not horizontal...

thanks a lot

records actualy. Again, my english might not be good enough. So I input a date and after that to be able to add automatically 6 other records with the 6 next dates. Since the last answer Im trying to figure it out how to use dateadd but no results yet. What I want is that the guy who's doing the...

what's the price for a regular beer in Eden, anyway? and because I feel you guys in the right mood, I ask the last question (today) -- In the form that covers the table x, I have a date field. Which have a date entered by the user. How can I fill the next 6 fields with the next 6 dates ...