Hi everyone,
I've been racking my brains over this one, so hopefully some kind soul can help.
My database contains many columns of mixed data.
E.G. Date, Number, Percentage etc.
I duplicated it in order to create a relationship. (It was all previously done on excel spreadsheet).
My question is this.....
Is there a way to do a search with the option of Equals Date, Does Not Equal Date, Is greater than date etc as in an auto-filter search as in excel.
If so could someone explain it as I am lost.
Incidentally, I would like to be able to have three or so different filters going at once.
E.G. greater than or equal to 1/1/2003 AND greater than 20% AND less than 2.
I have read the entire getting started manual and the full user guide, but just can't get my head around it.
any help greatly appreciated.
Dave.
