iwant to filter my data depend on date and cunsumerFamily in the following way:
for example month=2 AND cunsumerFamily=X
another example year=1985 AND cunsumerFamily=X
but i dont know how to write a sql statement for ADO filter property that contained both date and consumerFamily with conditions above.
any help will be appreciated
access 2000 database