Glad you have a working solution, although I think I might have approached this differently. I would have written code to create a single result set that has...

More "harmony" at work:

INPUT LENGTH IS KEY

TO COALESCE WITH ADMIN;

BEGIN FILLFACTOR

INSERT WITH ADMIN

NOT HAVING SOME CHARACTER;

CREATE ESCAPE PLAN

PLAN TO USE ROLLBACK

WHEN HAVING ADMIN NOT WITH

CHARACTER VALUES

Steve

(aka smunson)

:D:D:D

I'd be more concerned about the "can" influence, which might lead to this kind of thinking:

IF BACKUP EXISTS

TRIGGER DUMP PROCEDURE BY

ORDER OF USER

IF BACKUP EXISTS

TRIGGER DUMP PROCEDURE WITH

CHECK FOR DOUBLE...

"Do" is nothing more than another version of "While". Neither of them require any tie to a recordset - there are no such restrictions on their use.

Steve

(aka smunson)

:):):)

I'm going to suggest along another an entirely different line of thought. What reason do you have for aggregating all the e-mail addresses into a single line? ...

Another item that may add to your code but might make it a lot clearer...

I never use anything but the . commands within a With statement. I see...

Why not? SSMA has no reason to care that the server involved happens to be local. At least no reason I can think of, anyway. ...

Grovelli,

Why do you keep differentiating between "frontend" and "backend" ? If the tables are within the .mdb file, then THAT file IS the Access Database, and that's the...

One more attempt on my part:

DECLARE @MyHead TABLE

(

Row_ID INT,

Promo_ID INT,

...

As much as I hate to be the bearer of bad news, I really don't think there's any viable way for anyone to help you out here. The...

Unfortunately, that's not the result I end up with. I'm unable to refer to any Yes/No field by name. I've long ago given up on using...

Jeff,

He appears to just want a copy of the insert, so would replication meet his need, or would that cause problems on speed of "Updation" ?

Steve

(aka smunson)

:):):)

Just my two cents, but the OP has consistently NOT provided the exact details of the rules on which the output is based, and instead keeps adding more detail as...

I don't know, but you have to remember that there are three separate events for every key pressed. KeyDown, KeyPress, and KeyUp. They occur IN THAT...

Or this...

CREATE PROCEDURE

TO KILL CURRENT DATABASE

WHEN USER DUMMY

or ...

SET VARYING LENGTH

VALUES FOR UNION INPUT

TO GET UNIQUE DATE

Steve

(aka smunson)

:):):)