Select query criteria based on other field

[Ray]

I need to select all the records of a model in Model field if any records
has outstanding date in the Due Date field. Can someone give me some idea
to achieve it.

Model Due_Date
abc 10/11/03 <- Not selected
abc 09/09/03 <- Not selected
bbc 02/01/04 <- Selected
bbc 02/12/03 <- Selected

Thanks,

Ray

 

[Nikos Yannacopoulos]

Ray,

If you want to do this sticking to the design grid, I
would say you need two steps:
1. Totals Select query based on outstanding; Group By on
Model, Where on outstanding. This will return all models
with at least one outstanding line
2. Simple select query joining the original table with the
above query on Model.

HTH,
Nikos

 

[Ray]

Nikos,

Thanks for your useful advice and I work it out.

Ray