需要更新查询的帮助 [英] need help with update query

问题描述

您好，


我正在处理一个非常复杂的数据库，现在我正在尝试创建更新查询。查询显示的记录太少。我正在尝试更新表格库存中的数据。来自工作订单的数据表。查询只是复制最后一个工作订单。我想更新所有新工作人员到库存（可以直到100条记录）。


我真的很感谢你的帮助！谢谢！


Imke

Hello,

I am working on a very complex database and now I am trying to create an update query. The query is showing too few records. I am trying to update data in the table "inventory" with data from "workorder" table. The query is just copying the last workorder. I would like to update all new workorders to the inventory (can be until 100 records).

I would really appreciate your help! Thank you!

Imke

推荐答案

我们需要一些关于你的查询的信息。你可以发布查询/查询SQL代码吗？或者描述你申请的任何标准？


Jim

We''re going to need some info about what your query looks like. Can you post the query/queries SQL code? Or describe any criteria you''ve applied?

Jim

你好，


以下是SQL


UPDATE库存，WorkorderNewValve，[SQ客户和销售] INNER JOIN工作单ON [SQ客户和销售] .SalesID = Workorders.SalesID SET库存。[图纸＃] =左（[型号＃]，5）& [缩写]，Inventory.WorkorderNumber = [Forms]！[Sales Form]。[SalesID]& [WOIndex]，Inventory.Description = [WorkorderNewValve]。[part]，Inventory.Material = [Workorders]。[Material]，Inventory.Quantity = [WorkorderNewValve]。[Quantity]，Inventory.Remarks = [Workorders]。[备注] ]，库存。[区分标记] =更改

WHERE（（（Inventory.InventoryID）喜欢[Forms]！[First empty InventoryID]！[InventoryID]））;


这有帮助吗？谢谢...


Imke

Hello,

the following is the SQL

UPDATE Inventory, WorkorderNewValve, [SQ Customers and Sales] INNER JOIN Workorders ON [SQ Customers and Sales].SalesID = Workorders.SalesID SET Inventory.[Drawing#] = Left([Model#],5) & [Abbreviation], Inventory.WorkorderNumber = [Forms]![Sales Form].[SalesID] & [WOIndex], Inventory.Description = [WorkorderNewValve].[part], Inventory.Material = [Workorders].[Material], Inventory.Quantity = [WorkorderNewValve].[Quantity], Inventory.Remarks = [Workorders].[Remarks], Inventory.[Distinguishing Mark] = "changed"
WHERE (((Inventory.InventoryID) Like [Forms]![First empty InventoryID]![InventoryID]));

Does that help? Thank you...

Imke

由于我们没有数据，所以仍然很难看到，但是我猜想，从WHERE子句中使用术语''喜欢'，你想要以不完全匹配的形式输入。

如果是这种情况你需要像

It''s still hard to see too much because we don''t have the data, but I would guess, from the WHERE clause using the term ''Like'' that you wanted to enter in the form a non-exact match.
If that is the case you want something like

展开 | 选择 | Wrap | 行号

这篇关于需要更新查询的帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！