Summing a field not working.

[cope]

trying to sum a field called calculated downtime based on the date and line ID.


I have the command for the default value of my text box as:

DSum([Data].[Calculated Downtime], "Data", [date of incident] = "date in a textbox in this form" and [LineID] = "Line a")

Keeps returning #NAME.
any suggestions.

[cope]

Tried something different and using this in a query.
Line1DT: DSum([Data].[Calculated Downtime],"Data",[Data].[DATE of Inncident] = [Log times and products].[LogDate])
Says miss an , somewhere.

[CJ_London]

never seen a date with a value "date in a textbox in this form". Always help if you research how to use the functions - https://support.microsoft.com/en-us/office/dsum-function-08f8450e-3bf6-45e2-936f-386056e61a32

provide the names of your controls in your form that you are referencing.

but I would expect something like

dsum("[calculated downtime]","Data","[date of incident] = #" & format(me.txtDate,"yyyy-mm-dd") & "# and LineID=" & me.txtLineID)

[Welshgasman]

Also no need to prefix the fields with the source name. That is the second parameter in domain functions.

[June7]

Can't use Me in textbox or query, only in VBA behind form or report.