If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
writing expressions?
=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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
writing expressions?
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 he http://www.mvps.org/access/netiquette.htm "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 |
#4
|
|||
|
|||
writing expressions?
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 "ABDUL MUMTAZ" wrote: =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 |
Thread Tools | |
Display Modes | |
|
|