Can this SQL be modified to allow editing of the output fields?

SELECT tblProspectsNCDMVdealerList.DealerID AS ID,
tblProspectsNCDMVdealerList.DealerName AS Company,
tblProspectsNCDMVdealerList.Contact AS Contact,
tblProspectsNCDMVdealerList.DealerAddr1 AS Address,
tblProspectsNCDMVdealerList.DealerCity AS City,
tblProspectsNCDMVdealerList.DealerState AS ST,
tblProspectsNCDMVdealerList.DealerZip AS Zip,
tblProspectsNCDMVdealerList.DealerPhn AS Phone,
tblProspectsNCDMVdealerList.DlrEmail AS EMail,
tblProspectsNCDMVdealerList.FollowUp, "tblProspectsNCDMVdealerList" AS
TBL
FROM tblProspectsNCDMVdealerList
WHERE (((tblProspectsNCDMVdealerList.FollowUp)=True))

UNION SELECT tblProspectsNCGarages.TowCoID AS ID,
tblProspectsNCGarages.TowCoName AS Company,
tblProspectsNCGarages.TowCoContact AS Contact,
tblProspectsNCGarages.TowCoAddrLine1 AS Address,
tblProspectsNCGarages.TowCoCity AS City,
tblProspectsNCGarages.TowCoState AS ST, tblProspectsNCGarages.TowCoZip
AS Zip, tblProspectsNCGarages.TowCoPhn AS Phone,
tblProspectsNCGarages.TowCoEmail AS EMail,
tblProspectsNCGarages.FollowUp, "tblProspectsNCGarages" AS TBL
FROM tblProspectsNCGarages
WHERE (((tblProspectsNCGarages.FollowUp)=True))
ORDER BY Company;

Re: Can this SQL be modified to allow editing of the output fields?

MLH wrote:

> SELECT tblProspectsNCDMVdealerList.DealerID AS ID,
> tblProspectsNCDMVdealerList.DealerName AS Company,
> tblProspectsNCDMVdealerList.Contact AS Contact,
> tblProspectsNCDMVdealerList.DealerAddr1 AS Address,
> tblProspectsNCDMVdealerList.DealerCity AS City,
> tblProspectsNCDMVdealerList.DealerState AS ST,
> tblProspectsNCDMVdealerList.DealerZip AS Zip,
> tblProspectsNCDMVdealerList.DealerPhn AS Phone,
> tblProspectsNCDMVdealerList.DlrEmail AS EMail,
> tblProspectsNCDMVdealerList.FollowUp, "tblProspectsNCDMVdealerList" AS
> TBL
> FROM tblProspectsNCDMVdealerList
> WHERE (((tblProspectsNCDMVdealerList.FollowUp)=True))
>
> UNION SELECT tblProspectsNCGarages.TowCoID AS ID,
> tblProspectsNCGarages.TowCoName AS Company,
> tblProspectsNCGarages.TowCoContact AS Contact,
> tblProspectsNCGarages.TowCoAddrLine1 AS Address,
> tblProspectsNCGarages.TowCoCity AS City,
> tblProspectsNCGarages.TowCoState AS ST, tblProspectsNCGarages.TowCoZip
> AS Zip, tblProspectsNCGarages.TowCoPhn AS Phone,
> tblProspectsNCGarages.TowCoEmail AS EMail,
> tblProspectsNCGarages.FollowUp, "tblProspectsNCGarages" AS TBL
> FROM tblProspectsNCGarages
> WHERE (((tblProspectsNCGarages.FollowUp)=True))
> ORDER BY Company;

Not with a UNION query. I suppose you could send the output as a
MakeTable query to a table. I'd add a column to determine which table
it came from, then in the form that updates the MakeTable output you'd
update the table it origianlly came from when the record is saved.

Alive
http://www.youtube.com/watch?v=oymU3-OSWbo

Re: Can this SQL be modified to allow editing of the output fields?

On Jan 15, 12:13 pm, MLH wrote:
> SELECT tblProspectsNCDMVdealerList.DealerID AS ID,
> tblProspectsNCDMVdealerList.DealerName AS Company,
> tblProspectsNCDMVdealerList.Contact AS Contact,
> tblProspectsNCDMVdealerList.DealerAddr1 AS Address,
> tblProspectsNCDMVdealerList.DealerCity AS City,
> tblProspectsNCDMVdealerList.DealerState AS ST,
> tblProspectsNCDMVdealerList.DealerZip AS Zip,
> tblProspectsNCDMVdealerList.DealerPhn AS Phone,
> tblProspectsNCDMVdealerList.DlrEmail AS EMail,
> tblProspectsNCDMVdealerList.FollowUp, "tblProspectsNCDMVdealerList" AS
> TBL
> FROM tblProspectsNCDMVdealerList
> WHERE (((tblProspectsNCDMVdealerList.FollowUp)=True))
>
> UNION SELECT tblProspectsNCGarages.TowCoID AS ID,
> tblProspectsNCGarages.TowCoName AS Company,
> tblProspectsNCGarages.TowCoContact AS Contact,
> tblProspectsNCGarages.TowCoAddrLine1 AS Address,
> tblProspectsNCGarages.TowCoCity AS City,
> tblProspectsNCGarages.TowCoState AS ST, tblProspectsNCGarages.TowCoZip
> AS Zip, tblProspectsNCGarages.TowCoPhn AS Phone,
> tblProspectsNCGarages.TowCoEmail AS EMail,
> tblProspectsNCGarages.FollowUp, "tblProspectsNCGarages" AS TBL
> FROM tblProspectsNCGarages
> WHERE (((tblProspectsNCGarages.FollowUp)=True))
> ORDER BY Company;

You could always create a make-table query from it and then edit that
table. Ah, but that would be good design, wouldn't it? Sorry I
suggested it.