I'm not too sure how to get started on this, any help would be greatly apreciated!

I am working with 2 different tables: Customers and Transactions

From the Customer table I need to show the [Cust#],[Name] and [CreditType]. From the Transactions table I need to show the last [OrderDate].

I need to show Customers who have NOT placed an order within a certain date parameter. If they have placed an order within my specified date parameter I don't need to show that info.

This won't do a search of ALL our Customers because I have it narrowed to just "A" CreditType customers.

Let me know if I need to better explain anything. Thank you!!

Create a query so that you are showing customer and order date. Make the query a Totals query (View menu). Make all the fields group by except for order date which you make Max. Create a new query showing the results of the first query and in Criteria of the date field type <Dateadd("y",-1,now())

This will show all records older than a year.

Need a new query as I couldn't get the formula to work on a totals query!


HTH

[This message has been edited by Harry (edited 03-26-2002).]

Thanks for Replying Harry.

The trouble I am running into now is showing the last date that an "A" customer made an order. For example, we have 100 "A" clients and I run a query to show who out of our "A" clients made a purchase within say the last 30 days. Let's say 20 clients out of our 100 did NOT make a purchase. I need to show, out of those 20, the last date they made a purchase. Does that make sense?

Thanks again! - Derek

I figured it out. Thanks!