I have a query that is listed below. I need to develop a statement that would filter the month and the year as well as the Phase informaton in the access table. __________________________________________________________________
Select INMSP300.M3OE# as "OENo", INMSP300.M3OEC as "ComprsOE", INMSP300.M3PRD as "PN", INMSP300.M3CLS as "PrdLine", INMSP100.MSAPP, INMSP100.MSPRD, [strong]INMSP100.MSRDTM as "rtd-Month", INMSP100.MSRDTD as "rdc-Day", INMSP100.MSRDTY as "rtc-Year", INMSP100.[/strong]MSMPC as "Phase" From rdb.CARF1.INMSP300 INMSP300 join rdb.CARF1.INMSP100 INMSP100 on M3PRD = MSPRD Where INMSP300.M3CLS ='79'
I want to filter the spreadsheet so the [strong]INMSP100.MSRDTMas "rtd-Month" =11[/strong] and the [strong]rtc-Year=12[/strong], and then I need the [strong]INMSP100.MSMPC as "Phanse" grouped[/strong] as for lowest number to highest. Then numbers are few 1,2,3, and 4. So would it be a group or a "What"? What would I need to do to the this statement above to be able to accomplish this?
MS Access 2000, MSXP200,
October 23, 2009 12:43 PM
October 23, 2009 5:41 PM