greeetings all. i'm new to access as i'm more of an excel person. anyways i'm using an existing access database from a co-worker where i want to add a table into the main table that is pulling data from 1 other table.

here's the SQL command:
SELECT dd.SMT AS TBM, dd.[Cust Name] AS DealerName, dd.City, dd.State, d.Dealer, d.Product,
d.PIN, d.Description, d.SpendingPeriod, CCUR(IIF(d.Earned='-',0,nz(d.Earned,0))) AS Earned, CCUR(IIF(d.Spent='-',0,nz(d.Spent,0))) AS Spent, CCUR(nz(d.Balance,0)) AS Balance, d.Models, ddd.MaxSpend
INTO tblMainReport

FROM qry_Detail AS d

INNER JOIN tblDlrDump_F0101 AS dd ON d.Dealer = dd.Dealer;

i'm trying to add a column called "MaxSpend" from a table called tblPrgram and insert it with the other data into tblMainReport (i created a column for MaxSpend). I'm not certain where to and if to add another SELECT command line or add it into the command line with the others?

thanks for your help!