ok i think this did it?? Thanks
<cfquery name="rsStudio" datasource="kid"> SELECT tblStudio.StudioID, StuShort, StudioName, tblKid.StudioID, tblKid.KidDate FROM tblStudio, tblKid WHERE ((Month(tblKid.KidDate) NOT IN (#Month(todayDate)#)) AND (tblKid.StudioID <> tblStudio.StudioID)) GROUP BY tblStudio.StudioID, StuShort, StudioName, tblKid.StudioID, tblKid.KidDate ORDER BY StudioName ASC </cfquery> -paul -----Original Message----- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 3:29 PM To: CF-Talk Subject: Date Problems Again Hello What i am trying to do is a query for a select box I want to return all the StudioName's for this month who haven't already done a submission for this month. So if a studio has submitted this months form there name is no longer in the list, of studios who need to fill it out. But next month there name would be in the select again. i think AND (tblKid.StudioID <> tblStudio.StudioID)) would permanently hide the name But right now it is showing all the studios, even though is should be hiding a few. Any help would be great. -paul <CFSET todayDate = #DateFormat(Now(), "M/DD/YYYY")#> <cfquery name="rsStudio" datasource="kid"> SELECT tblStudio.StudioID, tblStudio.StuShort, tblStudio.StudioName, tblKid.StudioID, tblKid.KidDate FROM tblStudio, tblKid WHERE ((tblKid.KidDate NOT IN (#todayDate#)) AND (tblKid.StudioID <> tblStudio.StudioID)) GROUP BY tblStudio.StudioID, StuShort, StudioName, tblKid.StudioID, tblKid.KidDate ORDER BY StudioName ASC </cfquery> Studio <select name="StudioID" class="input"> <option value="">Select Studio</option> <cfoutput query="rsStudio" group="StudioID"> <option value="#rsStudio.StudioID#">#rsStudio.StudioName#</option> </cfoutput> </select> ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
