writing expressions?

[ABDUL MUMTAZ]

=DCount("OrderID";"[Cusoms]" Between " [Field18]" And "[Field23]"='" &
Forms!"[GenerlaOrders]"Between"[Text102]ÙŽ"And"[Text100]""')
Hi every body,
this expression is written in the form to count orders between 2 dates on
the General orders form which use the same dates as control source of the
table customs, no error message is received but no calculation is done.please
help me out with it

 

[Jack Leach]

I think the 'between' keyword will not work here... and date fields need to
be enclosed with "#". So something along the lines of:



"([Cusoms] >= #" & [field18] & "#) AND ([Cusoms] <= #" & [field23] & "#)"



This assumes that field18 is the low limit and field23 is the high limit.

hth

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)

 

[fredg]

=DCount("OrderID";"[Cusoms]" Between " [Field18]" And "[Field23]"='" &
Forms!"[GenerlaOrders]"Between"[Text102]î"And"[Text100]""')
Hi every body,
this expression is written in the form to count orders between 2 dates on
the General orders form which use the same dates as control source of the
table customs, no error message is received but no calculation is done.please
help me out with it

Answered elsewhere.
Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), crosspost by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.