Extracting Records

[naja]

I have a table that contains multiple accounts. each month I have filter
those accounts that I did not received and invoice. Is there a way on a query
that I can filter these accounts? I need to do this every month to report
accruals. Thanks for any help you can give me, is well appreciated.

 

[KARL DEWEY]

Try this substituting your table and field names --
SELECT [YourTable].*
FROM [YourTable]
WHERE ([YourTable].[Account] In (SELECT [XX].[Account] FROM [YourTable] AS
[XX] GROUP BY [XX].[Account])) AND (Format([YourTable].[PaidDate] , "yyyymm")
<> Format(DateAdd("m", -1, Date()), "yyyymm")));