View Single Post
  #2  
Old May 11th, 2009, 05:01 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default writing expressions?

How do you know that "no calculation is done" -- what happens?

Have you tried checking Access HELP for the syntax and examples of
DLookup()?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ABDUL MUMTAZ" wrote in message
...
=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