this is creating a table dynamically, i think; or what access might call a query?

I'm weak on Access formatting:

this is what i'm talking about:

this is your query reformatted for readability:

SELECT

admin_lookup_contract.contract_id,

admin_lookup_contract.contract_name,

admin_lookup_contract.contract_eff_date,

admin_lookup_contract.contract_exp_date,

admin_lookup_program_line.program_line_desc,

admin_lookup_vendor.vendor_name,

admin_lookup_contract.source_set_related_contracts

INTO

CAMS_Snapshot

FROM (admin_lookup_contract

INNER JOIN admin_lookup_program_line

ON admin_lookup_contract.program_line_id = admin_lookup_program_line.program_line_id)

INNER JOIN admin_lookup_vendor

ON admin_lookup_contract.vendor_key = admin_lookup_vendor.vendor_key

WHERE (( ( admin_lookup_contract.contract_exp_date ) > DATE() + 30 ));