Posted by Erland Sommarskog on 08/27/05 12:36

gethrog (gethrog@hotmail.com) writes:
> Having trouble with this assignment. My teachers say it should work but
> it just doesn't. This part of a macro is designed to take payment from
> the cost and show the balance owing. What am I doing wrong. The sql is
> shown below. No error message is showing but the process still dosen't
> work.
>
> UPDATE [wedding] INNER JOIN deal ON wedding.deal = deal.deal SET
> wedding.balance = (deal!cost - [wedding]!paid)

You should try this in comp.databases.ms-access. The syntax you use is
Access specific, as are the ! notation.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Key and Index on Same Column?
• Prev in forum: Re: Searching multiple entities at a time
• Thread view: Re: need help with SQL Macro in MS Access

[Reply to this message]