J
julostarr
Access 2003
I'm using the following subquery:
In (SELECT DISTINCT S.ShipMonth FROM [Shipping Information] AS S Inner JOIN
[Orders] as O ON.[Job#]= [O].[Job#] WHERE O.Invoiced = False OR
S.FinalShipDate is Null)
which does not select SHIP MONTHS in which every entry for that month has
completed INVOICED and FINAL SHIP DATE fields. I also have a SHIP YEAR
field, which currently only has 2008 & 2009. I have 2 almost identical
queries and in each I have criteria specifying for only one year to display.
In my 2008 query the month of FEB is displaying because I now have an entry
with a SHIP MONTH of FEB for the SHIP YEAR 2009 that has not been completed
even though it does not display in the query because of the criteria 2008
under the SHIP MONTH.
My question: Is there a way to specify within this subquery or add another
subquery to only select the SHIP MONTH of those entries with a SHIP YEAR of
2008?
Note* I also have an entry for JAN 2009, but it strangely does not display
in my 2008 query for some reason unknown to me.
julostarr
I'm using the following subquery:
In (SELECT DISTINCT S.ShipMonth FROM [Shipping Information] AS S Inner JOIN
[Orders] as O ON
S.FinalShipDate is Null)
which does not select SHIP MONTHS in which every entry for that month has
completed INVOICED and FINAL SHIP DATE fields. I also have a SHIP YEAR
field, which currently only has 2008 & 2009. I have 2 almost identical
queries and in each I have criteria specifying for only one year to display.
In my 2008 query the month of FEB is displaying because I now have an entry
with a SHIP MONTH of FEB for the SHIP YEAR 2009 that has not been completed
even though it does not display in the query because of the criteria 2008
under the SHIP MONTH.
My question: Is there a way to specify within this subquery or add another
subquery to only select the SHIP MONTH of those entries with a SHIP YEAR of
2008?
Note* I also have an entry for JAN 2009, but it strangely does not display
in my 2008 query for some reason unknown to me.
julostarr