generate date

[hair]

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 Actualy I would enjoy those beautiful 6 dates that your query creates to be vertical, not horizontal, that is the language that caracterise my real level in access..

 

[Mile-O]

How's this...?

 

[hair]

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

 

[Mile-O]

...it's even better now that it's in colour - I remember when the internet was in black and white

 

[Idjit]

Oh my Lord, you guys are like this even with a newbie in the serious forums?

 

[hair]

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

 

[Idjit]

I know this, hair - I just like to tease them from time to time.

 

[hair]

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

 

[chewy]

mile. Great example. I was going to change this to tke a beginning date and an ending date and put them in two seperate text boxes. How would I canculate the number of days between the numbers? Also if there is only one box shown I want it to show that it was only one day taken

 

[hair]

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

 

[Idjit]

mile. Great example. I was going to change this to tke a beginning date and an ending date and put them in two seperate text boxes. How would I canculate the number of days between the numbers? Also if there is only one box shown I want it to show that it was only one day taken

Here's a partial answer for you - the code to compute the number of days between 2 dates is:

=DateDiff("d",[StartDate],[EndDate])

 

[chewy]

I got the date to put in seperate boxes. But I still dont know how to count if it was a weekend and exclude those days