Updates/Inserts in Outer Join Query

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

Guest

My form is based on a query. I want to display all employee hours whether
Invoice has been received or not. If invoice is not there, then my form
should display blank fields. When new invoices come I need to update the
invoice fields and create a records in the invoice table. Is it possible to
do this?
 
Hi,


With Jet (dot-mdb file), use an outer join. Jet allows to update the
unpreserved side by appending a record, in that case. MS SQL Server does not
allow that, on the other hand.


SELECT a.*, b.*
FROM employee As a LEFT JOIN bills as b
ON a.employeeID = b.employeeID


can be tried, as example.


Hoping it may help,
Vanderghast, Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a form to input update query criteria 2
Restrict data in one field based on content of another 2
Access How to Validate the query parameter before loading the form that is based on the query iteself? 2
how can i open a report from a subform 4
Outlook Creating an Outlook form 2
Display name field in Forms 2
Form feeding a table problem 1
How to make select B subquery on select A? 2

Back
Top