Sum total by day

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to have an unbound text box that will sum the Field Redmond Yards
Poured by day. I have tried the following formula but with no result.
=Sum(Abs([tblyardsdate] Between Date() And Date())*[Yards Poured Redmond])

I believe it should be done with the day function but I a mnot sure how that
works.
 
This will return only the yards poured today. "total by day" suggests a
totals query like:

SELECT tblYardsdate, Sum([Yards Poured Redmont]) as DailySum
FROM tblYourTable
GROUP BY tblYardsDate;

Several things are very confusing:
-Do you actually have a field name that begins with "tbl"?
-Your expression returns a single value when your question expects multiple
date values
-[Yards Poured Redmond] suggests an unnormalized table structure since you
seem to be storing a location in a field name.
 
Back
Top