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!
Bookmarks