writing expressions?

  • Thread starter Thread starter ABDUL MUMTAZ
  • Start date Start date
A

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
 
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
 
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
 
Hi Abdul,

There is a problem with the construction of the parameters of the
function. To get a count of general orders between two dates try:

=DCount("[OrderID]","[your table's name]","[GeneralOrders] Between #" &
[Text102]ÙŽ & "# And #" & [Text100] & "#")

It is not clear how the "[Cusoms]" Between " [Field18]" And
"[Field23]"='" part is about. It also is malformed.

Do a search in Access's online help for DCount for more details on the
function.

Clifford Bass
 
Hi Abdul,

There is a problem with the construction of the parameters of the
function. To get a count of general orders between two dates try:

=DCount("[OrderID]","[your table's name]","[GeneralOrders] Between #" &
[Text102]ÙŽ & "# And #" & [Text100] & "#")

It is not clear how the "[Cusoms]" Between " [Field18]" And
"[Field23]"='" part is about. It also is malformed.

Do a search in Access's online help for DCount for more details on the
function.

Clifford Bass
 
Back
Top