Re: Please help!

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

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