I am trying to create export specifications for one of my queries. Now when I run the query on its own, it works perfectly. However when I try to export the data I get back the error message "Too few parameters. Expected 1." Has anyone encountered this before? Below is my SQL statement in case it helps:
SELECT ClaimDetail.cd_ ClaimId, BatchMaster.bm_ BatchId, ClaimDetail.cd_ BatchId, ClaimDetail.cd_ ClaimNum, ClaimDetail.exp ectedResult, ClaimDetail.REC _CODE_IN, ClaimDetail.DAT A_CENTRE_NUM, ClaimDetail.DAT A_CENTRE_SEQNUM , ClaimDetail.PAY EE_NUM, ClaimDetail.PRA CTITIONER_NUM, ClaimDetail.MSP _REGISTRATION, ClaimDetail.NAM E_VERIFY, ClaimDetail.DEP ENDENT_NUM, ClaimDetail.BIL LED_SRV_UNITS, ClaimDetail.SER VICE_CLARIFICAT ION, ClaimDetail.MSP _ANATOMICAL_ARE A, ClaimDetail.AFT ER_HOURS_SERVIC E_INDICATOR, ClaimDetail.NEW _PROGRAM_INDICA TOR, ClaimDetail.BIL LED_FEE_ITEM, ClaimDetail.BIL LED_AMOUNT, ClaimDetail.PAY MENT_MODE, ClaimDetail.SER VICE_DATE, ClaimDetail.SER VICE_TO_DAY, ClaimDetail.SUB MISSION_CODE, ClaimDetail.EXP ANDED_SUBMISSIO N, ClaimDetail.DIA GNOSTIC_CODE_1, ClaimDetail.DIA GNOSTIC_CODE_2, ClaimDetail.[DIAGNOSTIC_CODE _-3], ClaimDetail.DIA GNOSTIC_EXPAND, ClaimDetail.SER VICE_LOCATION_C D, ClaimDetail.REF _PRACT_1_CD, ClaimDetail.REF _PRACT_1, ClaimDetail.REF _PRACT_2_CD, ClaimDetail.REF _PRACT_2, ClaimDetail.TIM E_CALL_RECD_SRV , ClaimDetail.SER VICE_TIME_START , ClaimDetail.SER VICE_TIME_FINIS H, ClaimDetail.BIR TH_DATE, ClaimDetail.OFF ICE_FOLIO_NUMBE R, ClaimDetail.COR REPSONDENCE_COD E, ClaimDetail.CLA IM_SHORT_COMMEN T, ClaimDetail.MVA _CLAIM_CODE, ClaimDetail.ICB C_CLAIM_NUM, ClaimDetail.ORI GINA_MSP_FN, ClaimDetail.FAC ILITY_NUM, ClaimDetail.FAC ILITY_SUB_NUM, ClaimDetail.FIL LER_CLAIM_C02_R CD, ClaimDetail.OIN _INSURER_CODE, ClaimDetail.OIN _REGISTRATION, ClaimDetail.OIN _FIRST_NAME, ClaimDetail.OIN _SECOND_NAME, ClaimDetail.OIN _SURNAME, ClaimDetail.OIN _SEX_CODE, ClaimDetail.OIN _ADDRESS_1, ClaimDetail.OIN _ADDRESS_2, ClaimDetail.OIN _ADDRESS_3, ClaimDetail.OIN _ADDRESS_4, ClaimDetail.OIN _POSTAL_CODE
FROM BatchMaster INNER JOIN ClaimDetail ON BatchMaster.bm_ BatchId = ClaimDetail.cd_ BatchId
WHERE (((BatchMaster. bm_BatchId)=[Forms]![BatchMainForm]![bm_BatchId]));
I have 2 tables - Master/Detail
Expand|Select|Wrap|Line Numbers
- BatchMaster
- ---------------
- bm_BatchId PK AutoNumber
- bm_BatchNum Text
- bm_Description Text
- ClaimDetail
- --------------
- cd_ClaimId PK AutoNumber
- cd_BatchId Number
- cd_ClaimNum Text
- etc.
Thanks guys, any help is appreciated.
---Punker