Parsing Problem. 2

[Hanss]

Strings one and two work fine, but when I try to combine them get a parsing error:

One - This works:

?DEnd("[area]","last", BuildCriteria("[station]",dblong,"=" & Forms![dcform]![station]))

Two - This works:

?DEnd("[area]","last", BuildCriteria("[process]",dblong,"= 1"))

I tried to combine one and two as follows BUT get a parsing error:

?DEnd("[area]","last", BuildCriteria("[station]",dblong,"=" & Forms![dcform]![station] AND [process]",dblong,"= 1"))

I would REALLY appreciate any help on where the parsing error is.

Kind regards,
Hanss
Zurich, Switzerland

 

[PHV]

Any chance you could post the definition (code) of your functions (DEnd and BuildCriteria)

Long shot in the dark:
?DEnd("[area]","last", BuildCriteria("[station]",dblong,"=" & Forms![dcform]![station]) & " AND " & BuildCriteria("[process]",dblong,"= 1"))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JohnLowell]

try This:

?DEnd("[area]","last", BuildCriteria("[station]",dblong,"=" & Forms![dcform]![station] & " AND [process] = 1"))

 

[Hanss]

Thank you both for your fast replies!!!

I tried both strings and one worked. JohnLowell's string works like a charme.

kind regards,
hanss