Select query criteria based on other field

  • Thread starter Thread starter Ray
  • Start date Start date
R

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
 
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
 
Back
Top