Macro not working

#1

Quote:

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 payments, add them
together then subtract them from the cost and show the balance owing. What
am I doing wrong. The sql macro 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)

#2

I'm not sure, but I can tell you that no one with experie4nce would
ever name a field in a table with the same name as the table.
deal.deal
is a very bad idea, even if it isn't your problem.

Good luck
Ira Solomon

On Sat, 27 Aug 2005 10:20:47 GMT, "gethrog" <gethrog (AT) hotmail (DOT) com>
wrote:

Quote:

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 payments, add them
together then subtract them from the cost and show the balance owing. What
am I doing wrong. The sql macro 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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Macro not working

comp.database.ms-access comp.database.ms-access

Macro not working - 08-27-2005 , 05:20 AM

Re: Macro not working - 08-27-2005 , 03:19 PM