By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,745 Members | 1,577 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,745 IT Pros & Developers. It's quick & easy.

Time isn't on my side

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

P: n/a
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

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.