Hi anyone able to answer this nugget…?.I have an access 97 DataBase (45mb).I have run a query to find out who has given us business in the past year.Fine:Out of 3000 customers we had 500 giving us business in past year(I used the >#31/12/99# function).What I cannot do however is run a query on who has not given us business in past year.How do find data when there is nothing to search on(ie:Date business given).I have tried to work out how to remove the 500(business given)from the total 3000(customers)but am getting very confused.Is there an easy way to acheive this.Thanx for your help(hoping!!!)…Gary
