R
Roger
I have Access 2002 SP3 on XP. I have a table of client names. Linked to that
table is another table of payments made by client (client nr, amount, date).
I have a query to find the last payment made by a client ... the
payment-amount and payment-date but only if the payment was made more than 1
month ago (that is, no payments made in the last month).
I have used the Group By "Last" option in my query for the date field
payment-date, and put a criteria in >(Now())-28, but for a couple of clients
I get strange results ... some payment-date results are within a month and
in 2 cases I have two "Last" records ... obviously I have done something
wrong. Can someone help me please
thanks heaps ... Roger
table is another table of payments made by client (client nr, amount, date).
I have a query to find the last payment made by a client ... the
payment-amount and payment-date but only if the payment was made more than 1
month ago (that is, no payments made in the last month).
I have used the Group By "Last" option in my query for the date field
payment-date, and put a criteria in >(Now())-28, but for a couple of clients
I get strange results ... some payment-date results are within a month and
in 2 cases I have two "Last" records ... obviously I have done something
wrong. Can someone help me please
thanks heaps ... Roger