Missing Operator Problem

[Benjamin]

Hi everybody,

i have an little Problem with an expression in my query.
Im using the DSum(DomSumme in german) function to sum up
productionquantitys per month. The problem with that is
that DSum only should sum up the quantites ("Stückzahl")
of the last 12 month or 365 days ([Datum] means Date). I
made an expression but access needs an operator in the " &
ZDouble([Datum])=>" & ZDouble([Datum])-365 criteria. I
don`t know which operator i got to use.

Thanks for your help so far

With best regards
Benjamin

My Expression:
Mitarbeiterproduktion1: Wert(Nz(DomSumme
("Stückzahl";"Mitarbeiterproduktion";" & ZDouble([Datum])
=>" & ZDouble([Datum])-365)))

 

[Douglas J. Steele]

Michel's already given you an answer that should work.

I just wanted to point out that Greater Than Or Equal To is >=, not =>. I
suspect that was the cause of your error.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Hi everybody,

i have an little Problem with an expression in my query.
Im using the DSum(DomSumme in german) function to sum up
productionquantitys per month. The problem with that is
that DSum only should sum up the quantites ("Stückzahl")
of the last 12 month or 365 days ([Datum] means Date). I
made an expression but access needs an operator in the " &
ZDouble([Datum])=>" & ZDouble([Datum])-365 criteria. I
don`t know which operator i got to use.

Thanks for your help so far

With best regards
Benjamin

My Expression:
Mitarbeiterproduktion1: Wert(Nz(DomSumme
("Stückzahl";"Mitarbeiterproduktion";" & ZDouble([Datum])
=>" & ZDouble([Datum])-365)))

 

[Michel Walsh]

Hi,


DSum(("Stückzahl", "TableNameHere", "Date( ) - DatumField <= 365
" )


Since the function Date( ) returns today date, Now( ) returns today with
actual time, for info. The difference of two Date_value is in number of
days, already (and decimal, for hours, such as 0.5 = 12 hours, half a day).



Hoping it may help
Vanderghast, Access MVP

Hi everybody,

i have an little Problem with an expression in my query.
Im using the DSum(DomSumme in german) function to sum up
productionquantitys per month. The problem with that is
that DSum only should sum up the quantites ("Stückzahl")
of the last 12 month or 365 days ([Datum] means Date). I
made an expression but access needs an operator in the " &
ZDouble([Datum])=>" & ZDouble([Datum])-365 criteria. I
don`t know which operator i got to use.

Thanks for your help so far

With best regards
Benjamin

My Expression:
Mitarbeiterproduktion1: Wert(Nz(DomSumme
("Stückzahl";"Mitarbeiterproduktion";" & ZDouble([Datum])
=>" & ZDouble([Datum])-365)))

 

[Benjamin]

Hi,

expression from Mr. Vandergast works well.
Only a litte question on the Date() is it
possible to replace Date() with an Field out of
an query or table ?


Thanks for all

With best regards

Benjamin

 

[Douglas J. Steele]

Assuming that the field is a Date field, there should be no problem.