Re: Please help!

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?

.

Loading