Hi there,
Access DB with 2 tables.
Table A is client details
Table B is order details.
I am trying to find unrelated records, which is easy if a client has no orders in the orders table.
However, every month a client makes an order. I want to create a query to see which month the client didn’t make an order.
For example:
January – placed order
February – no order
March – placed order
It would be easy to find if the client had null orders, but I just want to find the missing ones.
It would also be easy if it was just a few clients, I would then filter manualy, however with over 10000 clients I have to create a query.
Any help on this would be greatly appreciated.
