Thank you for helping me... Stewart~! it works...
however, i have a further question... instead of using like "*", can i use another way to do it??
because if i use "like", it takes a very long time to run.... especially for a very huge table... ( i have a table for more than 7 billions records)
Thank you,
talllight...
talllight
Last Activity: Mar 17 '08, 10:28 PM
Joined: Feb 28 '08
Location:
-
Hey Stewart,
Thank you for replying.
However, i guess you have misunderstood my question.
i have a dropbox in a form.
in the dropbox, i have, as the example, "1" or "2" or "3" or "ALL".
while i select "ALL" in the drop box and run the query, the result should include all the values from the table.
Let me know if you still do not...Leave a comment:
-
try this...
=sum(Count([Case]) ,DCount("*","EM HS New Closed Appeals Preview")...Leave a comment:
-
if statement with null criteria
hey,
i am trying to create a query to get result which linked to a value from a form.
the following is an example of a database...
[FieldA]
A1
A1
B2
C3
in the criteria box of Field A,
i have
switch( [FormA]![field1] = "1" , "A1", [FormA]![field1] = "2", "B2", [FormA]![field1] = "3", "C3"....
No activity results to display
Leave a comment: