ms access - Dsum Function in Query Field not working properly -

-

i have date based query returns 2 fields, week ending date , l2n, , want add third field provides rolling total of l2n field. have tried using dsum follows:

runl2n: dsum("[l2n]","occupied apts & l2n", "week ending date=" & "'" & [week ending date] & "'")

in code above, l2n field want sum, , occupied apts & l2n query returns fields. query asks week ending date , delivers of records equal or proceed given week ending date.

it no worky right. goal runl2n field show rolling total of l2n field each record. in other words, if query returns multiple records, want show l2n field result, , show run2l2n field, sums l2n fields of records above , current record.

so if query returns 1 in l2n field, 3 next record, 5 next record , lastly 7 final record, want runl2n field show 1 first record, 4 next record, 9 next record , lastly 16 final record.

since field name includes spaces, bracket this: [week ending date]

assuming it's date/time type, use # delimiters before , after date value.

finally think want sum rows [week ending date] <= date in current row.

dsum("[l2n]","occupied apts & l2n", "[week ending date]<=" & format([week ending date], "\#yyyy-m-d\#"))

however if use correlated subquery, instead of dsum(), compute running sum of l2n, won't have bother delimiters date value.

select     y1.[week ending date],     y1.l2n,     (         select sum(y2.l2n)         [occupied apts & l2n] y2         y2.[week ending date] <= y1.[week ending date]     ) runl2n [occupied apts & l2n] y1;

Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

-
i have following code almost works properly; private void cbstatus_drawitem(object sender, listboxdrawitemeventargs e) { string item = e.item string; if (item != null) { switch (item) { case "1": e.appearance.forecolor = color.green; e.appearance.backcolor = color.green; break; case "2": e.appearance.forecolor = color.orange; e.appearance.backcolor = color.orange; break; case "3": e.appearance.forecolor = color.red; e.appearance.backcolor = color.red; break; } } } when dropdown shown, items forecolor correct, backcolor remains whatever backcolor of theme is; i.e. if i've got set dark theme, backcolor dark, cells in gridview, rather being green/orange/red. i've tried setting e.appearance.options.usebackcolor trying set e....
Read more

django - Creating multiple model instances in DRF3 -

-
1) create multiple model instances 1 api call, asked here: how create multiple model instances django rest framework? tried solution named in link, no success. i trying upload multiple files in 1 api call. result: files uploaded (only once overwrote perform_create) 1 instance created (if send 2 files, latter created instance). my code: class fileuploadserializer(serializers.modelserializer): def __init__(self, *args, **kwargs): many = kwargs.pop('many', true) super(fileuploadserializer, self).__init__(many=many, *args, **kwargs) class meta: model = fileupload read_only_fields = ('created', 'datafile', 'owner') class fileuploadviewset(viewsets.modelviewset): queryset = fileupload.objects.all() serializer_class = fileuploadserializer parser_classes = (multipartparser, formparser, ) def perform_create(self, serializer): file_list = self.request.data.getlist('file') ...
Read more