Query Save Error

[imnewtoaccess]

Hi All,

Whenever i try to save a query, I get an error 'Inavlid Argument'. But I can execute the query and get the desired result. I want to use the query in another query to generate a file.

Pls Help....this is urgent.

Thanks in advance.

[JKing]

Could you post the SQL for the query?

[imnewtoaccess]

Could you post the SQL for the query?

This is the query.

SELECT "S0400016" AS LINE_HEADER, Format(TK_TCK_SALE_DETAILS1.DATE,'mmddyyyy') & Format(TK_TCK_SALE_DETAILS1.TIME,'hhnn') AS PURCHASE_TIME, Mid(TK_TCK_SALE_DETAILS1.WORKCODE,9,2) & '.' & FORMAT(RIGHT(CSTR(TK_TCK_SALE_DETAILS1.TCK_NBR),3),'000') & '.' & Format(TK_TCK_SALE_DETAILS1.DATE,'mmddyy') AS TRANSACTION_CODE, TK_IMPORT_TICKET1.TK_SERIAL_EXTERNAL AS TICKET_BARCODE, TK_PROGRAM_DETAILS1.SHORT_NAME AS TICKET_CODE, Format((TK_TCK_SALE_DETAILS1.TRANS_PRICE-TK_TCK_SALE_DETAILS1.USH_REVENUE)*100,'00000') AS TICKET_REVENUE, Replace(Space(25),Space(1),'0') & '00011' & Replace(Space(10),Space(1),'0') & Space(35) & Replace(Space(20),Space(1),'0') AS HARD_CODED_PARK_ID, TK_CATEGORY.CAT_SUB_NAME, TK_PROGRAM_DETAILS1.PROGRAM_ID
FROM ((TK_IMPORT_TICKET1 INNER JOIN TK_TCK_SALE_DETAILS1 ON TK_IMPORT_TICKET1.TK_SERIAL_INTERNAL = TK_TCK_SALE_DETAILS1.TK_SERIAL) INNER JOIN (TK_TICKET_TYPE INNER JOIN TK_CATEGORY ON TK_TICKET_TYPE.CAT_ID = TK_CATEGORY.CAT_ID) ON TK_TCK_SALE_DETAILS1.TCK_TYPE = TK_TICKET_TYPE.TCK_TYPE) INNER JOIN TK_PROGRAM_DETAILS1 ON TK_TICKET_TYPE.TCK_TYPE = TK_PROGRAM_DETAILS1.TCK_TYPE
WHERE (((TK_CATEGORY.CAT_SUB_NAME)="ONLINE TICKET STORE") AND ((TK_PROGRAM_DETAILS1.PROGRAM_ID)="SCVP" Or (TK_PROGRAM_DETAILS1.PROGRAM_ID)="SCVPI") AND ((TK_TCK_SALE_DETAILS1.DATE) Between [Start_Purchase_Date] And [End_Purchase_Date]))
ORDER BY TK_TCK_SALE_DETAILS1.DATE;

THanks.