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

 

[Jeff Boyce]

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

 

[Jeff Boyce]

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

 

[BruceM]

You have posted this same question separately in at least three different
groups. Cross-post (one message to several groups at once) if you must, but
avoid mulit-posting (copies of the same message to several different
groups). More here:
http://www.mvps.org/access/netiquette.htm

 

[BruceM]

You have posted this same question separately in at least three different
groups. Cross-post (one message to several groups at once) if you must, but
avoid mulit-posting (copies of the same message to several different
groups). More here:
http://www.mvps.org/access/netiquette.htm

 

[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

 

[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