Re: Please help!

Allen, I inserted it into an existing query, and when I went to run it, it
prompted an "Enter Parameter Value: Date-Start" then an "Enter Parameter
Value: Time-Finish". Is there a way I can draw the dates already in the
query to use in figuring the difference in time without being prompted?
Should I have a Total row?
--
Joe


"Allen Browne" wrote:

Whatever you like.

--
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.

"joet5402" <joet5402@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:428AFC54-EE83-4F3A-9572-782826C94E41@xxxxxxxxxxxxxxxx
Allen, should this be in a new query or in an existing query
that contained the previously mentioned fields?
--
Joe


"Allen Browne" wrote:

Sorry: there should be a comma between the field names:
Minutes: DateDiff("n", [DATE-START], [TIME-FINISH])

"joet5402" <joet5402@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2CD5A749-D5CE-4E9C-9679-7DEF7D5616D9@xxxxxxxxxxxxxxxx
Allen, after I deleted the "Duration" field, I entered the Minutes:
DateDiff("n", [DATE-START] [TIME-FINISH]) formula into a query, but I
got
an
error message saying, "The expression you entered contains invalid
syntax.
You may have entered an operand without an operator". How can this be
fixed?
--
Joe


"Allen Browne" wrote:

Set the Default View property of your form to:
Continuous

Now you put only *one* row of controls in the form's Detail section.
When you run the form, it repeats the row for every record.

Remove the Time-Duration field from your table.
Instead, create a query, and type this into a fresh column in the
Field
row:
Minutes: DateDiff("n", [DATE-START] [TIME-FINISH])
You can then sum the minutes and do whatever you want.

More details about there in:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

"joet5402" <joet5402@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D129E73B-3126-418B-A48E-D43F8F2F2C84@xxxxxxxxxxxxxxxx
I'm currently working on the following form (from a Field List):

(these are in form header section)
TECHNICIAN-START DATE-START TIME-FINISH TIME-DURATION

TECHNICIAN-START DATE-START TIME-FINISH TIME-DURATION
TECHNICIAN
TECHNICIAN
TECHNICIAN
TECHNICIAN
TECHNICIAN
etc.
(all these are text boxes in Detail section)

This is my problem: How do I get the fields below the initial line
to
not
duplicate any of the data from the initial line (TECHNICIAN-START
DATE-START
TIME-FINISH TIME-DURATION)? Also, how do I create a total duration
time?


.

Relevant Pages

  • Re: Please help!
    ... If your table has fields named DATE-START and TIME-FINISH, Access should understand what you are talking about. ... Perhaps the table is not in the query. ... Allen Browne - Microsoft MVP. ... >>> Joe ...
    (microsoft.public.access.forms)
  • Re: Please help!
    ... should this be in a new query or in an existing query ... Allen Browne - Microsoft MVP. ... Remove the Time-Duration field from your table. ... Calculating elapsed time ...
    (microsoft.public.access.forms)
  • Re: need help creating criteria for time
    ... Allen Browne - Microsoft MVP. ... I then removed the criteria and left everything else and ran it ... Now let's verify that these date/time fields have *only* date or time, ... If you switch your query to SQL View (View menu, ...
    (microsoft.public.access.queries)
  • Re: a query to produce sales activity totals
    ... The query generates a row for each salesperson, ... Allen Browne - Microsoft MVP. ... of the sales process, including the number of sold and delivered vehicles. ... put these totals into a spread sheet that shows each salesperson's ...
    (microsoft.public.access.queries)
  • Re: Problem with Send Object
    ... Inserted into criteria of report query: ... How are you passing that filter string to the report, ... Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.formscoding)
Loading