Date: 06/06/05 (SQL Server)    Keywords: sql

Hi Gang -

trying to run a make-table query. Can someone look at the SQL and tell me why access keeps returning an "Invalid Arguement" error.
Thanks in advance




SELECT BI.NRS_STATION, BI.BED_ABBREV, PHM_ORDERS.ADDL_SIG_1, PHM_ORDERS.ADDL_SIG_2, PHM_ORDERS.ADDL_SIG_3, PHM_ORDERS.ADDL_SIG_4, BI.PTNAME, BI.PAT_NUM, BI.PTSEX, BI.PTAGE, BI.PTMEDREC, BI.ITN, BI.PTCLASS, BI.ATTDOCNU, BI.ATTDOCNA, BI.SITE, PHM_ORDERS.PMP, PHM_ORDERS.MED_IV, PHM_ORDERS.COMPONENT_TYPE, PHM_ORDERS.DOSE, PHM_ORDERS.START_DATE, PHM_ORDERS.STOP_DATE, PHM_ORDERS.STOP_TIME, PHM_ORDERS.LATIN_DIR_ABBR, PHM_ORDERS.FREQUENCY, PHM_ORDERS.ROUTE, PHM_ORDERS.DR_NO, PHM_ORDERS.DR_NAME, PHM_ORDERS.GENERIC_NAME, PHM_ORDERS.DOSAGE_FORM, PHM_ORDERS.DRUG_CODE, PHM_ORDERS.SOL_VOLUME, PHM_ORDERS.RATE, PHM_ORDERS.RUN_IN_TIME, PHM_ORDERS.VALIDATED_BY, PHM_ORDERS.IV_METHOD, PHM_ORDERS.CANCELLED, PHM_ORDERS.SUSPEND_DATE, PHM_ORDERS.SUSPEND_TIME, PHM_ORDERS.RESUME_DATE, PHM_ORDERS.RESUME_TIME, PHM_ORDERS.STRENGTH, PHM_ORDERS.ACTIVE_COMPONENT, PHM_ORDERS.ACTIVE_UB, PHM_ORDERS.SUSPENDED, PHM_ORDERS.STOPPED INTO mart
FROM BI INNER JOIN PHM_ORDERS ON BI.ITN = PHM_ORDERS.ITN
WHERE (((BI.PAT_NUM)=[Forms]![frm_mar]![ctlptno]) AND ((BI.ITN)>"0") AND ((PHM_ORDERS.VALIDATED_BY)<>"") AND ((PHM_ORDERS.ACTIVE_COMPONENT)="YES") AND ((PHM_ORDERS.ACTIVE_UB)<>"NO") AND ((PHM_ORDERS.SUSPENDED)="NO") AND ((PHM_ORDERS.STOPPED)="NO"));

Source: http://www.livejournal.com/community/sqlserver/27880.html