Zdouble Problem

[Benjamin]

Hi,

i have an DSum function to sum the "Stückzahl"(quantity),
in that function i got an Zdouble criteria. The Zdouble
refers to "Datum"(date). I want that all "Stückzahl"
entries in the database which are at maximum 365 days
older than the entered date of the dataset are summed up
with the dsum function.
I tried the best i could but it doesnt work.
The only thing i get was #Error

Thanks for your helping

Benjamin


My Expression:
Mitarbeiterproduktion1: Val(Nz(DomSumme
("Stückzahl";"Mitarbeiterproduktion";"DatePart('m',[Datum])
<=" & [A1Month] & " And DatePart('yyyy',[Datum])<=" &
[A1Year] & " And ZDouble([Datum])=>" & ZDouble([Datum])-
365 & "");""))

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not sure about this, because of difference between English and German
version, but, you may try:

Mitarbeiterproduktion1: Val(Nz(DomSumme
("Stückzahl";"Mitarbeiterproduktion";"DatePart(""m"",[Datum])
<=" & [A1Month] & " And DatePart(""yyyy"",[Datum])<=" &
[A1Year] & " And ZDouble([Datum])=>" & ZDouble([Datum])-
365);""))

I put doubled double-quotes ("") around the month indicator (m) and the
year indicator (yyyy) in the DatePart() function.

I removed the ampersand and doubled double-quotes from after the 365 in
the last line. Using the ampersand and quotes turns the value into a
string, which means you cannot perform a mathematical calculation on the
string "365."

Is DSum DomSumme in the German version? If NOT change to DSum.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQS0DOoechKqOuFEgEQJsFwCg+aLJQv/vJBAaQxNahMf5ut5jQqUAoM3I
eHc1yZPqvOfJnd5KHCW3WEP/
=axnm
-----END PGP SIGNATURE-----