访问报告问题 [英] Problem with Access Report

问题描述

我的报告输出有问题。它基于多个查询，适用于一个处理器。如果我选择不同的处理器，报告不会产生任何结果。它只是对所有领域都有空白。在任何
查询中，我对客户没有任何限制。请帮忙。 

I have a problem with report output. It base on multiple queries and work fine for one Processor. If I select different Processor, report does not produce any results. It just have blanks for all fields. I do not have any restrictions for customers in any queries. Please help. 

这是我的SQL：

SELECT Main_tracking.DateReceived，Main_tracking.PaymentType，Main_tracking.Processor，Main_tracking.VSID，[出生总和] .SumOfAdjSumofNoreq，[出生总和]。[SumOfBirth WC]，[出生总和]。[SumOfBirth Search]，[出生总和]。[SumOfBirth WC Total]，[
出生总和] 。[SumOfBirth NV]，[出生总和]。[SumOfBirth Total]，[出生总和] .TypeReq，[死亡之和] .SumOfAdjSumofNoreq，[死亡之和]。[SumOfDeath WC]，[死亡之和]。 [SumOfDeath Search]，[死亡之和]。[SumOfDeath WC Total]，[死亡之和]。[SumOfDeath NV]，
[死亡之和] .SumOfCoroner，[死亡之和]。[SumOfDeath Total] ，[死亡之和] .TypeReq，[出生总和] .SumOfCount，[出生总和] .SumOfsearch，[死亡之和] .SumOfCount，[死亡之和] .SumOfsearch，[出生总和]。[SumOfSum of noreq]，[死亡之和]。[SumofSum
of noreq]，Sum（Requested_Certificates.WCRefundAmont）AS SumOfWCRefundAmont，（[SumOfBirth Total] + [SumOfDeath Total]）AS TotWORefund，Nz（[SumOfWCRefundAmo] nt]）+ Nz（[TotWORefund]）AS GrandTotal，drawers.depitcredit

SELECT Main_tracking.DateReceived, Main_tracking.PaymentType, Main_tracking.Processor, Main_tracking.VSID, [Sum of Birth].SumOfAdjSumofNoreq, [Sum of Birth].[SumOfBirth WC], [Sum of Birth].[SumOfBirth Search], [Sum of Birth].[SumOfBirth WC Total], [Sum of Birth].[SumOfBirth NV], [Sum of Birth].[SumOfBirth Total], [Sum of Birth].TypeReq, [Sum of Death].SumOfAdjSumofNoreq, [Sum of Death].[SumOfDeath WC], [Sum of Death].[SumOfDeath Search], [Sum of Death].[SumOfDeath WC Total], [Sum of Death].[SumOfDeath NV], [Sum of Death].SumOfCoroner, [Sum of Death].[SumOfDeath Total], [Sum of Death].TypeReq, [Sum of Birth].SumOfCount, [Sum of Birth].SumOfsearch, [Sum of Death].SumOfCount, [Sum of Death].SumOfsearch, [Sum of Birth].[SumOfSum of noreq], [Sum of Death].[SumOfSum of noreq], Sum(Requested_Certificates.WCRefundAmont) AS SumOfWCRefundAmont, ([SumOfBirth Total]+[SumOfDeath Total]) AS TotWORefund, Nz([SumOfWCRefundAmont])+Nz([TotWORefund]) AS GrandTotal, drawers.depitcredit

FROM抽屉INNER JOIN（（（Main_tracking INNER JOIN Requested_Certificates ON Main_tracking.TrackingID = Requested_Certificates.AppID）INNER JOIN [死亡总和] ON（Main_tracking.Processor = [死亡总和] .Processor）AND（Main_tracking.DateReceived = [Sum
of Death] .DateReceived））INNER JOIN [出生总和] ON（[出生总和] ] .Processor = Main_tracking.Processor）AND（Main_tracking.DateReceived = [出生总和] .DateReceived））ON（drawers.Processor = Main_tracking.Processor）AND（drawers.DateReceived = Main_tracking.DateReceived）

FROM drawers INNER JOIN (((Main_tracking INNER JOIN Requested_Certificates ON Main_tracking.TrackingID = Requested_Certificates.AppID) INNER JOIN [Sum of Death] ON (Main_tracking.Processor = [Sum of Death].Processor) AND (Main_tracking.DateReceived = [Sum of Death].DateReceived)) INNER JOIN [Sum of Birth] ON ([Sum of Birth].Processor = Main_tracking.Processor) AND (Main_tracking.DateReceived = [Sum of Birth].DateReceived)) ON (drawers.Processor = Main_tracking.Processor) AND (drawers.DateReceived = Main_tracking.DateReceived)

GROUP BY Main_tracking.DateReceived，Main_tracking.PaymentType，Main_tracking.Processor，Main_tracking.VSID，[出生总和] .SumOfAdjSumofNoreq，[出生总和]。[SumOfBirth WC]，[出生总和]。[SumOfBirth Search ]，[出生总和]。[SumOfBirth WC Total]，[Sum
of Birth]。[SumOfBirth NV]，[出生总和]。[SumOfBirth Total]，[Sum of Birth] .TypeReq，[Sum死亡] .SumOfAdjSumofNoreq ，[死亡之和]。[SumOfDeath WC]，[死亡之和]。[SumOfDeath Search]，[死亡之和]。[SumOfDeath WC Total]，[死亡之和]。[SumOfDeath NV]，
[死亡之和] .SumOfCoroner，[死亡之和]。[SumOfDeath Total]，[死亡之和] .TypeReq，[出生总和] .SumOfCount，[出生总和] .SumOfsearch，[死亡之和] .SumOfCount ，[死亡之和] .SumOfsearch，[出生总和]。[noreq的SumOfSum]，[死亡之和]。[noreq的SumOfSum
]，（[SumOfBirth Total] + [SumOfDeath Total]），抽屉.depitcredit

GROUP BY Main_tracking.DateReceived, Main_tracking.PaymentType, Main_tracking.Processor, Main_tracking.VSID, [Sum of Birth].SumOfAdjSumofNoreq, [Sum of Birth].[SumOfBirth WC], [Sum of Birth].[SumOfBirth Search], [Sum of Birth].[SumOfBirth WC Total], [Sum of Birth].[SumOfBirth NV], [Sum of Birth].[SumOfBirth Total], [Sum of Birth].TypeReq, [Sum of Death].SumOfAdjSumofNoreq, [Sum of Death].[SumOfDeath WC], [Sum of Death].[SumOfDeath Search], [Sum of Death].[SumOfDeath WC Total], [Sum of Death].[SumOfDeath NV], [Sum of Death].SumOfCoroner, [Sum of Death].[SumOfDeath Total], [Sum of Death].TypeReq, [Sum of Birth].SumOfCount, [Sum of Birth].SumOfsearch, [Sum of Death].SumOfCount, [Sum of Death].SumOfsearch, [Sum of Birth].[SumOfSum of noreq], [Sum of Death].[SumOfSum of noreq], ([SumOfBirth Total]+[SumOfDeath Total]), drawers.depitcredit

HAVING（（（Main_tracking.DateReceived）= [输入日期]）AND（（Main_tracking.PaymentType）=" credit / debit"））;

HAVING (((Main_tracking.DateReceived)=[Enter Date]) AND ((Main_tracking.PaymentType)="credit/debit"));

推荐答案

当您说"选择处理器"时，它是什么意思？您在哪里选择处理器以及您的查询或报告中使用的选择如何？

What does it mean when you say to "select a processor?" Where are you selecting the processor and how is the selection used in your query or report?

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