Dick7Access
Dick S
- Local time
- Today, 04:53
- Joined
- Jun 9, 2009
- Messages
- 4,203
[FONT="]I am just studying the “dateDiff” function. [/FONT]
[FONT="]On the instructions below it says “Create a query into this table” [/FONT]
[FONT="]1. [/FONT][FONT="]Is he just saying make a query from table x or is there something I don’t know about queries?[/FONT]
[FONT="]2. [/FONT][FONT="]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="]Instruction in tutorial:[/FONT]
[FONT="]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="] Minutes: DateDiff("n", [StartDateTime], [EndDateTime])[/FONT]
[FONT="]On the instructions below it says “Create a query into this table” [/FONT]
[FONT="]1. [/FONT][FONT="]Is he just saying make a query from table x or is there something I don’t know about queries?[/FONT]
[FONT="]2. [/FONT][FONT="]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="]Instruction in tutorial:[/FONT]
[FONT="]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="] Minutes: DateDiff("n", [StartDateTime], [EndDateTime])[/FONT]