在“两个表"字段的基础上重新添加为MS-Access查询. [英] Releted to MS-Access Query on the basis of Two Tables fields.

问题描述

CFD_UPB与表tblReportVectors和AnnualIRR_Calc有关，与我想要的表tblReviewScalars有关(CFD_UPB)*(AnnualIRR_Calc).
我在两个表上都使用了内部联接，但是当我运行查询时它会生成一个弹出窗口并要求首先放置CFD_UPB值，然后在该弹出窗口中放置AnnualIRR_Calc，但是我不希望从弹出窗口中获取.该查询是否有任何解决方案.

CFD_UPB it is related to table tblReportVectors and AnnualIRR_Calc it is related to table tblReviewScalars i want (CFD_UPB)*(AnnualIRR_Calc).
i got anwers using inner join on both table but it generate one popup when i am run the query & ask to put CFD_UPB value first & then AnnualIRR_Calc throught that popup but i did''nt want that from Popup . is there any solution on that query.

推荐答案

我一直(不幸地)一直使用MS-Access，建议您使用查询设计器来构建复杂的查询而不是SQL视图(仅语法).这样，您可以处理查询以获得正确的结果.


然后，您可以转到SQL视图并复制要在VBA代码模块中使用的实际SQL字符串.

HTH.让我知道您是否还有其他疑问.

I use MS-Access all the time (unfortunately) and I recommend that you use the Query designer to build your complex queries and not the SQL view (syntax only). This way you can play with the query to get the right results.


You can then go to SQL view and copy the actual SQL string to use in your VBA code modules.

HTH. Let me know if you have any further questions on this.

这篇关于在“两个表"字段的基础上重新添加为MS-Access查询.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！