Question

Locked

MS Access 2003 Query missing/unrelated data

By dvdza ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

A couple of questions

by unhappyuser In reply to MS Access 2003 Query miss ...

Do you have a relationship between the two tables?

You could do a count funtion that that shows months where Count=0. Be sure your grouping is set up correctly else it may not come up with the correct numbers. I have a form that I could email you as there's not enough space to write all of it in here.

EMD

Collapse -

Answers

by dvdza In reply to A couple of questions

Hi EMD,

Yep, primary key field in my clients table is in a relationship with a clientId field in the orders table.

Let me try the count function, if I don't come right I'll definately come back.

Thanks for the reply.

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums