S
Scott
I have a DCount function on report footer as below:-
DCount("*","TableName", "[DateField] between #MM/DD/YY# and #MM/DD/YY#")
It works correctly but the date format must be American way MM/DD/YY,
European way. Other dates in use are all European way. Why does DCount use
American way? Is it possible to change to European way?
I use the same method with a query but it produced #Error
DCount("*","QueryName", "[DateField] between #MM/DD/YY# and #MM/DD/YY#")
The query is a parameter query requiring to enter start date and end date.
Can I use parameter input to replace the fixed criteria in DCount function.
Thanks,
Scott
DCount("*","TableName", "[DateField] between #MM/DD/YY# and #MM/DD/YY#")
It works correctly but the date format must be American way MM/DD/YY,
European way. Other dates in use are all European way. Why does DCount use
American way? Is it possible to change to European way?
I use the same method with a query but it produced #Error
DCount("*","QueryName", "[DateField] between #MM/DD/YY# and #MM/DD/YY#")
The query is a parameter query requiring to enter start date and end date.
Can I use parameter input to replace the fixed criteria in DCount function.
Thanks,
Scott