DateDiff Function

Dick7Access

Dick7Access

Dick S
Local time
Today, 08:39
Joined
Jun 9, 2009
Messages
4,338
[FONT=&quot]I am just studying the “dateDiff” function. [/FONT]
[FONT=&quot]On the instructions below it says “Create a query into this table” [/FONT]
[FONT=&quot]1. [/FONT][FONT=&quot]Is he just saying make a query from table x or is there something I don’t know about queries?[/FONT]
[FONT=&quot]2. [/FONT][FONT=&quot]And “type this into field row of the query design grid” Is he saying into a blank grid, or am I missing what field he is talking about?[/FONT]
[FONT=&quot]Instruction in tutorial:[/FONT]
[FONT=&quot]Let's assume a date/time field named StartDateTime to record when the employee clocks on, and another named EndDateTime for when the employee clocks off. To calculate the time worked, create a query into this table, and type this into the Field row of the query design grid:[/FONT]
[FONT=&quot] Minutes: DateDiff("n", [StartDateTime], [EndDateTime])[/FONT]
 
I don't think there is authoritative language in this regard. Do we "create a query based on a table", or "query records from a table," or, heaven forbid, "extract records from a table as the result of employing a query." Why not "query into a table?" I don't think it's ambiguous at all.

The "Field" row: Look at the first field in the query design grid. Now look to the left of it. You'll see the rows are labelled, with "Field" as the first. There is also a Table row, and a Sort row.

hth
 
MarkK said:
I don't think there is authoritative language in this regard. Do we "create a query based on a table", or "query records from a table," or, heaven forbid, "extract records from a table as the result of employing a query." Why not "query into a table?" I don't think it's ambiguous at all.

The "Field" row: Look at the first field in the query design grid. Now look to the left of it. You'll see the rows are labelled, with "Field" as the first. There is also a Table row, and a Sort row.

hth
Click to expand...
Thanks for answering. yes I know all the rows are labeled, then I guess I must put it in an empty column of the Field row, and that's what I meant when I said "in a blank grid", I should have said an empty column in field row. It didn't seem right that it should go in a column by itself. . I haven’t worked much with functions. Up until now I have done everything I could with embedded macros. I am trying to revamp all my db, so I am picking lots of different functions and see what they do.
 
If you think about it in simple terms you will get it.

Let's say you want to find your real age, i.e. the difference in years between your date of birth and today. You would enter the following (where 19/07/1930 is your date of birth):
Code: 
DateDiff("yyyy", #19/07/1930#, Date())
... which will yield 85 years :)

Focus more on what you want to use the function for. Don't get confused by its use in the help files.
 
vbaInet said:
If you think about it in simple terms you will get it.

Let's say you want to find your real age, i.e. the difference in years between your date of birth and today. You would enter the following (where 19/07/1930 is your date of birth):
Code: 
DateDiff("yyyy", #19/07/1930#, Date())
... which will yield 85 years :)

Focus more on what you want to use the function for. Don't get confused by its use in the help files.
Click to expand...

The problem was that I have used very little functions in queries. A few times when I did I just copied from somebodies code to get the job done but did not understand what was happening. Now I am just studying. After I understood were to put the function it worked. I don't need it anyplace. What I just tried was to get the second record to calculate, it won't calculate but I like trying and learning as am not up against a clock.
 
vbaInet said:
Slowly but surely.

Not until your wife wants another recipe db for summer dishes :D
Click to expand...

Go ahead, rub it in!

I don't get much time for computing when I am on the road, and Lord willing I leave for GA in a week and a half, and when I come back I'll be home maybe three weeks and then head to Carrabele, FL, Slidall, LA, Kilgore, TX, Hallesville, TX and maybe Amarillo, TX. So many restaurants, so few meals.
 
That wasn't a negative comment Dick ;)

She definitely knows how to keep you busy. I wonder how many dbs you have now.
 
vbaInet said:
That wasn't a negative comment Dick ;)

She definitely knows how to keep you busy. I wonder how many dbs you have now.
Click to expand...

Oh! I didn't take it as negative, I should have put a smile face after "rub it in"
In fact I eat up, she is my ego trip.
It is something when she says make it do "such and such", and I say "I can't", and she looks at me with this innocent look, and says "why not"
To me Access is like a cross-word puzzle to some people, except when I figure out my puzzle it has a usefully purpose. She is not the only one that I make db for.
I love helping people and I especially like helping people with Access. In my circle I am the expert. they just don't know it's you guy that are backing me up.
 
vbaInet said:
That wasn't a negative comment Dick ;)

She definitely knows how to keep you busy. I wonder how many dbs you have now.
Click to expand...

Oops I missed the "How Many" line. Last time I counted it was around 28 just for her and total with everybody probable around 100. One of these days I need to learn excel a little better, but every-time I goggle something in access I find something else I didn't even know about.
 
Dick7Access said:
Oh! I didn't take it as negative, I should have put a smile face after "rub it in"
In fact I eat up, she is my ego trip.
It is something when she says make it do "such and such", and I say "I can't", and she looks at me with this innocent look, and says "why not"
To me Access is like a cross-word puzzle to some people, except when I figure out my puzzle it has a usefully purpose. She is not the only one that I make db for.
I love helping people and I especially like helping people with Access. In my circle I am the expert. they just don't know it's you guy that are backing me up.
Click to expand...
She needs to set you much harder tasks
tongue.gif
And don't worry, you can take all the glory
biggrin.gif


Dick7Access said:
Oops I missed the "How Many" line. Last time I counted it was around 28 just for her and total with everybody probable around 100. One of these days I need to learn excel a little better, but every-time I goggle something in access I find something else I didn't even know about.
Click to expand...
That's quite a lot! I think a few years back you mentioned (or I hinted) that you were/should consolidate. Did you make any headway in this regard?
 
vbaInet said:
She needs to set you much harder tasks
tongue.gif
And don't worry, you can take all the glory
biggrin.gif


That's quite a lot! I think a few years back you mentioned (or I hinted) that you were/should consolidate. Did you make any headway in this regard?
Click to expand...

[FONT=&quot]Oh! Absolutely, that's why I don't have an accurate count as I have deleted some after I combined them. Just for my sister alone there was a db for her prison visitation ministry, and one for her prison correspondence course. I was going to include one for Reformers Unanimous class for addiction but she quit. I don't think she used any of them anymore. The db that they had for RU was always crashing, and some people ask me to look at it, and it was a mess. However, the guy that made it was a little touchy about the normalization I wanted to do so I backed off. [/FONT]
 
vbaInet said:
That wasn't a negative comment Dick ;)

She definitely knows how to keep you busy. I wonder how many dbs you have now.
Click to expand...

The laugh is on me!!!!! I am at the rehab hospital and she wants a db where she can type in the three numbers of the red, green, blue and a field will turn that color. I told her it can't be done, but told her I would ask? If it can be done what do I goggle?
 
She's always looking for new functionality ;)
You can look into the RGB() function.
 
I have goggled everything I can find on Hex function and can't seem to wrap my brain around it. Can somebody give a generic snippet.
 
I gave you a link in my prior post. That will convert a decimal to a Hex number.

A color string needs to be 6 characters:

FF9900

The first two (FF) designate the red value, the second two (99) designate green and the last two (00) designate blue. An issue you might run into is that the Hex function doesn't pad 0's onto the left. So Hex(7) will return 7 and not 07. You would have to catch that and pad it with the 0 to make your final string 6 characters.

Also, its a 256 color pallet, meaning if the user inputs 312 for green, its an invalid input. They can only input numbers 0-255 for valid colors.
 
You must log in or register to reply here.

Similar threads

Technics
Add clock values to report query
2 3 4
Replies
61
Views
3,210
Gasman
Gasman
Papa_Bear1
Getting an error 3825, complaining about multi-valued fields, but none are involved.
2
Replies
25
Views
1,018
Papa_Bear1
Papa_Bear1
S
Link records between two tables based on range?
Replies
3
Views
733
Mark_
M
X
When was my Worker's Last Day Off?
Replies
3
Views
727
MarkK
MarkK
F
Your Query does not include the specified Expression ‘ID’ as part of an Aggregate Function
Replies
8
Views
1,806
June7
June7

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom