Time isn't on my side

[Steve M]

I have a field in a query that shows various times stored in a table
(7:40 PM, 8:10 AM, etc.). I want to create an expression in another
field in the query that will add 10 minutes to each time from the
first field. So when I run the query I will have 2 columns. Column 1:
7:40 PM, 8:10 AM and Column 2: 7:50 PM, 8:20 AM. I know it must be
simple but I can't write an expression that works right.
Thanks

[PC Datasheet]

What do you ant to do if the time in the first column is between 11:50PM and
1159 PM? Adding 10 minutes will take you into the next day.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Steve M" <st****@crprod.com> wrote in message
news:de**************************@posting.google.c om...

I have a field in a query that shows various times stored in a table
(7:40 PM, 8:10 AM, etc.). I want to create an expression in another
field in the query that will add 10 minutes to each time from the
first field. So when I run the query I will have 2 columns. Column 1:
7:40 PM, 8:10 AM and Column 2: 7:50 PM, 8:20 AM. I know it must be
simple but I can't write an expression that works right.
Thanks

[Allen Browne]

Assuming the field is called StartTime, and you want the calculated field
called EndTime, type this into the Field row of the query design grid:

EndDate: DateAdd("n", 10, [StartTime])

Be sure to use N for miNutes. M adds months.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Steve M" <st****@crprod.com> wrote in message
news:de**************************@posting.google.c om...

I have a field in a query that shows various times stored in a table
(7:40 PM, 8:10 AM, etc.). I want to create an expression in another
field in the query that will add 10 minutes to each time from the
first field. So when I run the query I will have 2 columns. Column 1:
7:40 PM, 8:10 AM and Column 2: 7:50 PM, 8:20 AM. I know it must be
simple but I can't write an expression that works right.
Thanks

[Steve M]

Thanks, I think I see where the mistake was in my expression. I will
try this when I get to work.
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<40**********************@per-qv1-newsreader-01.iinet.net.au>...

Assuming the field is called StartTime, and you want the calculated field
called EndTime, type this into the Field row of the query design grid:

EndDate: DateAdd("n", 10, [StartTime])

Be sure to use N for miNutes. M adds months.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Steve M" <st****@crprod.com> wrote in message
news:de**************************@posting.google.c om...

I have a field in a query that shows various times stored in a table
(7:40 PM, 8:10 AM, etc.). I want to create an expression in another
field in the query that will add 10 minutes to each time from the
first field. So when I run the query I will have 2 columns. Column 1:
7:40 PM, 8:10 AM and Column 2: 7:50 PM, 8:20 AM. I know it must be
simple but I can't write an expression that works right.
Thanks