SQL make table query

[iroosma]

I am trying to update code from an old program. The old code is

SELECT ins.CNAME,ins.ATTN,ins.STREET,ins.CITY,ins.ST,
ins.ZIP, policy.BCO, policy.POL, policy.EFF,
policy.NEXP, ap3dbfb.YEAR,ap3dbfb.MAKE,ap3dbfb.MODEL,
ap3dbfb.VIN, ap3dbfb.ST, carrier.CNAME, ins.REC
INTO findata
FROM (ins INNER JOIN (ap3dbfb INNER JOIN policy ON
ap3dbfb.polREC=left(policy.pol_idx,9))
ON (ins.REC=policy.REC) AND (ins.REC=ap3dbfb.REC)) INNER JOIN carrier ON policy.BCO=carrier.REC;

Im not sure how to write a make table querey that will do this. I started to but it wouldn't even let me SELECT that many fields. I will appreciate any help you can give.

Thanks

 

[lespaul]

ummm, that is a make table query.

Where it says:

INTO findata

that's the table it's trying to insert the information into.

The SQL you posted looks valid, what happens if you just run it in the SQL view? Do you get the new table? An error? What version of Access are you using?

Leslie