How do I make this an Updatable Query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't understand the concept of what makes one query updatable and another
not updatable

I would like to update records directly from my form but this is not an
updatable query. What do I need to do to make this updatable? .

SELECT dbo_tblAccounts.AccountName, [Accounts Recievable].[DATE BILLED],
[Accounts Recievable].[AMOUNT BILLED], [Accounts Recievable].[DATE PAID],
[Accounts Recievable].[CHECK #], [Accounts Recievable].[AMOUNT PAID],
[Accounts Recievable].ALLOW, [Accounts Recievable].[OPEN BALANCE], [Accounts
Recievable].[CASH ACCOUNT], [Accounts Recievable].Discount, [Accounts
Recievable].INVNUM, dbo_tblAccounts.PrimaryPhoneNumber,
dbo_tblAccounts.PrimaryFaxNumber, dbo_tblAccounts.PrimaryEmailAddress,
dbo_tblAccounts.Address1, dbo_tblAccounts.Address2, dbo_tblAccounts.City,
dbo_tblAccounts.State, dbo_tblAccounts.PostalCode,
dbo_tblAccounts.AccountNumber
FROM [Accounts Recievable] INNER JOIN dbo_tblAccounts ON [Accounts
Recievable].[BILL TO] = dbo_tblAccounts.AccountingCompanyId
ORDER BY [Accounts Recievable].[DATE BILLED];

Thanks in advance for any light you may be able to shed on this for me.
 
I don't understand the concept of what makes one query updatable and another
not updatable

I would like to update records directly from my form but this is not an
updatable query. What do I need to do to make this updatable? .

SELECT dbo_tblAccounts.AccountName, [Accounts Recievable].[DATE BILLED],
[Accounts Recievable].[AMOUNT BILLED], [Accounts Recievable].[DATE PAID],
[Accounts Recievable].[CHECK #], [Accounts Recievable].[AMOUNT PAID],
[Accounts Recievable].ALLOW, [Accounts Recievable].[OPEN BALANCE], [Accounts
Recievable].[CASH ACCOUNT], [Accounts Recievable].Discount, [Accounts
Recievable].INVNUM, dbo_tblAccounts.PrimaryPhoneNumber,
dbo_tblAccounts.PrimaryFaxNumber, dbo_tblAccounts.PrimaryEmailAddress,
dbo_tblAccounts.Address1, dbo_tblAccounts.Address2, dbo_tblAccounts.City,
dbo_tblAccounts.State, dbo_tblAccounts.PostalCode,
dbo_tblAccounts.AccountNumber
FROM [Accounts Recievable] INNER JOIN dbo_tblAccounts ON [Accounts
Recievable].[BILL TO] = dbo_tblAccounts.AccountingCompanyId
ORDER BY [Accounts Recievable].[DATE BILLED];

Thanks in advance for any light you may be able to shed on this for me.
Click to expand...

Search Access Help:
Query + When can I update data from a query? + Data can't be updated
 
Back
Top