Append Query - Error Message

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

Hello:

I am running this append query, it runs fine up until I
add "0018" & Format([w_releaseln].[seqno],"0000000") AS
expr6 - First it tells me how many records it will append
then the next screen it gives me the following
message "Microsoft Access Cant append al the records in
append query"

INSERT INTO [tbl_0022_(W12)Warehouse Item Detail] (
[Quantity Ordered], [No of Units Shipped], [Vendor No],
[Shipment Order Status Code], [Product Service ID
Qualifier], [Seq No], ItemID, RecordID, Parent )
SELECT First(W_RELEASELN.QTY) AS FirstOfQTY1, First
(W_RELEASELN.QTY) AS FirstOfQTY, First(W_RELEASELN.PRODNO)
AS FirstOfPRODNO, First("SH") AS Expr1, First("VN") AS
Expr2, Format([w_releaseln].[seqno],"000000") AS
expr3, "0022" & Format(w_releaseln.seqno,"0000000") AS
expr4, DMax("[RecordID]","[tbl_0001_(W06)Warehouse
Shipment ID]") AS Expr5, "0018" & Format([w_releaseln].
[seqno],"0000000") AS expr6
FROM [tbl_0022_(W12)Warehouse Item Detail], [Number],
(W_RELEASE INNER JOIN W_RELEASELN ON W_RELEASE.RELEASENO =
W_RELEASELN.RELEASENO) INNER JOIN Start ON
W_RELEASE.RELEASENO = Start.ReleaseNo
GROUP BY Format([w_releaseln].[seqno],"000000"), "0022" &
Format(w_releaseln.seqno,"0000000"), Start.ReleaseNo, DMax
("[RecordID]","[tbl_0001_(W06)Warehouse Shipment
ID]"), "0018" & Format([w_releaseln].[seqno],"0000000")
HAVING (((Start.ReleaseNo)=[Start]![ReleaseNo]));

Thanks.

Pat
 
After the Can't Append message, what does it say the reason is. Key
Violation, Data Type Mismatch, etc.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top