[AccessD] Subqueries assistance please

Hi David

To put one query into another, look up the archives for
  "SQL in-line subquery"

The easiest way to extract the value to a textbox is to use DLookup:

  =DLookUp("[Weeks]","[qdyYourCombinedQuery]")

/gustav