Repeating records in Query

I reorganized my queries and set them up differently, they are working
perfectly now. Thanks for all your help!
--
Thorson


"Ron2006" wrote:

Sorry about no reply yesterday. Too many fires to put out.

What I think I am suggesting is that you develop a separte query that
includes the drug list and the off label table. The end result would
be a single time frame for the given drug (dosage?). make it so that
you will always have the drug and then if there is no offlabel record
then the time is from the drug list but if there is an offlabel
record, then you would output the offlabel time.

Then use this as a substitute for the druglist in your query. This
will get one of the complications out of the already complicated
query.

I will try to take another look at the problem this afternoon - time
permitting.

Ron