Tiosylanyl
New Member
- Joined
- Jul 31, 2006
- Messages
- 48
Hello,
I have two tables that are linked by a "client" ID number. One table represents every shipment we have made to a client, the other table represents clients that have been discharged from our services, and the dates they were discharged.
I am trying to set up a query such that I can pull all the patients discharged within the last 12 months and then pull data on all shipments for the twelve months prior to the client being discharged.
I know a round about way of doing this, but it requires a lot of manipulation and time that I may not always have. I was wondering if anyone had any ideas on how to set this up on a single query to cut down on time investment in doing this.
Thanks in advance.
I have two tables that are linked by a "client" ID number. One table represents every shipment we have made to a client, the other table represents clients that have been discharged from our services, and the dates they were discharged.
I am trying to set up a query such that I can pull all the patients discharged within the last 12 months and then pull data on all shipments for the twelve months prior to the client being discharged.
I know a round about way of doing this, but it requires a lot of manipulation and time that I may not always have. I was wondering if anyone had any ideas on how to set this up on a single query to cut down on time investment in doing this.
Thanks in advance.