加入ms访问查询 [英] Join query for ms access

问题描述

我有一个ms访问文件有3个表命名TAXINVOICE，InvoiceItems，产品。

Taxinvoice表包含INVOICENO，STATE，CUSTOMERNAME，ADDRESS1



InvoiceItems表包含InvoiceItemId，InvoiceNumber，ProductId，Quantity，UOM，UnitPrice，GrossAmount，VAT，VatAmount，TAX。

产品表包含ProductId，ProductName

i想要更新查询基于textboxvalue（InvoiceNo）



我尝试过：



iam ms in ace aceess查询 我不知道ms访问查询

i have one ms access file having 3 table naming TAXINVOICE,InvoiceItems,products.
Taxinvoice table contains INVOICENO,STATE,CUSTOMERNAME,ADDRESS1

InvoiceItems table contain InvoiceItemId,InvoiceNumber,ProductId,Quantity,UOM,UnitPrice,GrossAmount,VAT,VatAmount,TAX.
products table contains ProductId,ProductName
i want update query for based on textboxvalue(InvoiceNo)

What I have tried:

iam new in ms aceess queries i have no idea about ms access query

推荐答案

从这里开始：如何：使用Access SQL从表中插入，更新和删除记录  [Access 2007 Developer Reference] [ ^ ]



回到这里当你遇到困难时。

Start here: How to: Insert, Update, and Delete Records From a Table Using Access SQL [Access 2007 Developer Reference][^]

Come back here when you get stuck.

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