Re: concatenating with a append query

John,
Here is the SQL :
INSERT INTO [Active Archived] ( circuitid, customer_account, project_name,
sub_project, sub_project_1, business_unit, ratm_contact, research_completed,
handoff_date, followup_date, nextfollowup_date, fixing_dept, fixing_name,
sales_rep, date_resolved, rev_comment, mrc_revenue, nrc_revenue, supportDI,
bill_cycle, monthinyear, mso_number, misc_comment, root_cause, eckkt, vendor,
fc_handoff, fc_hold, fc_datesent, fc_costsavings, fc_comment, fc_comment1,
bam_ticket_no, bam_status, bam_dollars, mrc_billing_stopped, credit_comment,
business_line, product_type, product_tier, access_type, Customer_Name,
status, control_id, Teoco_date, rastatus, category, sales_order_id,
oe_order_id, service_cat_code, invoiced, Fix, IDTag, dbId )
SELECT MasterData.circuitid, MasterData.customer_account,
MasterData.project_name, MasterData.sub_project, MasterData.sub_project_1,
MasterData.business_unit, MasterData.ratm_contact,
MasterData.research_completed, MasterData.handoff_date,
MasterData.followup_date, MasterData.nextfollowup_date,
MasterData.fixing_dept, MasterData.fixing_name, MasterData.sales_rep,
MasterData.date_resolved, MasterData.rev_comment, MasterData.mrc_revenue,
MasterData.nrc_revenue, MasterData.supportDI, MasterData.bill_cycle,
MasterData.monthinyear, MasterData.mso_number, MasterData.misc_comment,
MasterData.root_cause, MasterData.eckkt, MasterData.vendor,
MasterData.fc_handoff, MasterData.fc_hold, MasterData.fc_datesent,
MasterData.fc_costsavings, MasterData.fc_comment, MasterData.fc_comment1,
MasterData.bam_ticket_no, MasterData.bam_status, MasterData.bam_dollars,
MasterData.mrc_billing_stopped, MasterData.credit_comment,
MasterData.business_line, MasterData.product_type, MasterData.product_tier,
MasterData.access_type, MasterData.Customer_Name, MasterData.status,
MasterData.control_id, MasterData.Teoco_date, MasterData.rastatus,
MasterData.category, MasterData.sales_order_id, MasterData.oe_order_id,
MasterData.service_cat_code, MasterData.invoiced, MasterData.Fix,
MasterData.IDTag, MasterData.dbId
FROM MasterData
WHERE (((MasterData.circuitid)=[forms]![frmMain]![circuitid]));

"John Spencer (MVP)" wrote:

> Could you post the SQL statement you are using to do the append?
>
> INSERT INTO TargetTableName
> (dbID, field1, field2, Field3, ...)
> SELECT "MyDBIDvalue", S.Field1, S.Field2, S.Field3
> FROM SourceTableName AS S
>
> If you DBID is a number field then you don't need the quotes around whatever the
> db value is. A
>
> Raj wrote:
> >
> > I have a database that is used to archive old data from 5 other database.
> > All of the databases have a field "dbid", including the archive database,
> > which is defaulted when the user adds a new entry. I have a button on the
> > main for of the database that appends to the archived database and deletes it
> > from the current database. I would like to have the "dbid" from the current
> > database concatenated to "dbid" of the archive database, when it is appended
> > how can I do this in my append query?
> > Thank you..
>
.

Loading