Well.I guess it would help to have the right query pasted in here. There are only 4 fields that I am using criteria on. WHERE (((qryPanasonicShirtCheckNew2.) Is Null)) ![]() = qryPanasonicShipCheckNewProgram.qryAllDemosByDateR ange. = qryPanasonicShirtCheckNew2.) ON qryAllDemosbyDateRange. SELECT qryAllDemosbyDateRange.ProjectCode, qryAllDemosbyDateRange., qryAllDemosbyDateRange., qryAllDemosbyDateRange.Store_No, qryAllDemosbyDateRange., qryAllDemosbyDateRange., qryAllDemosbyDateRange.Shirt_size, qryAllDemosbyDateRange.ShippingNumber, qryPanasonicShirtCheckNew2.įROM qryAllDemosbyDateRange RIGHT JOIN (qryPanasonicShipCheckNewProgram LEFT JOIN qryPanasonicShirtCheckNew2 ON qryPanasonicShipCheckNewProgram.qryAllDemosByDateR ange. ![]() I thought I might not have copied all the records.but the standalone table has the records above 25841 in it Is it possible that you failed to copy all the records?.Could you post the SQL from the "bad" query?.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |