RE: Error in Delete Query
- From: djkc <djkc@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 18 Aug 2008 08:56:02 -0700
I forgot to include the SQL view of my query:
DELETE [Paid out credex Accts].BranchNumber, [Paid out credex Accts].Name,
[Paid out credex Accts].SSN, [Paid out credex Accts].Acct, [Paid out credex
Accts].LoanClass, [Paid out credex Accts].Balance, [Paid out credex
Accts].Term, [Paid out credex Accts].RegularPayment, [Paid out credex
Accts].LoanDate, [Paid out credex Accts].FirstPaymentDate, [Paid out credex
Accts].StatusCode, [Paid out credex Accts].PledgeCode, [Paid out credex
Accts].ContrDelqCode, [Paid out credex Accts].[AD&DTerm], [Paid out credex
Accts].[AD&DPrem], [Paid out credex Accts].NonFileFee, [Paid out credex
Accts].Operator, [Paid out credex Accts].NextDueDate, [Paid out credex
Accts].LastPaymentDate, [Paid out credex Accts].AutoPrem
FROM [Open Credex Loans] INNER JOIN [Paid out credex Accts] ON [Open Credex
Loans].SSN = [Paid out credex Accts].SSN;
"djkc" wrote:
I made a query to check socials from an active tbl against socials from an.
inactive table. I run the query with a left join so that both fields are
equal to show me all the inactive socials that are in the active tbl. I need
these deleted out of the inactive tbl so I change my query type from select
to delete and recieve the error specify the table you want the records to be
deleted from. Anyone know how to get around this?
- Follow-Ups:
- Re: Error in Delete Query
- From: John Spencer
- Re: Error in Delete Query
- References:
- Error in Delete Query
- From: djkc
- Error in Delete Query
- Prev by Date: RE: Update table data
- Next by Date: Re: How do I setup Fiscal Yr to begin in October in Access
- Previous by thread: Error in Delete Query
- Next by thread: Re: Error in Delete Query
- Index(es):
Relevant Pages
|
