Microsoft SQL Server forum - need help with SQL Macro in MS Access

Author

need help with SQL Macro in MS Access

gethrog

2005-08-27, 3:23 am

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)

Erland Sommarskog

2005-08-27, 7:23 am

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/techin.../2000/books.asp

Sponsored Links