过滤报告 [英] Filter on Report

问题描述

我想过滤HorseID / InvoiceDate，因为每个HorseID / InvoiceDate只会显示一个报告

I want to filter HorseID/InvoiceDate so as only one report per HorseID/InvoiceDate will show

Thansk可以提供任何帮助.... Bob

Thansk for any help....Bob

私人子报告_打开（取消为整数）

    

    Report.RecordSource =" SELECT Distinct tblInvoice.InvoiceDate，tblInvoice.InvoiceID AS InvoiceID，" _
$
    &安培; " tblHorseInfo.HorseID，funGetHorse（0，tblHorseInfo.HorseID，false）AS Name，[StableReturnDate]" _
$
    &安培; " FROM tblInvoice，tblHorseInfo其中tblHorseInfo.HorseID" _
$
    &安培; " = tblInvoice.HorseID" _
$
    &安培; "和tblInvoice.HorseID =" &安培;表格！frmActiveFinishedNew！[tbHorseID]

Private Sub Report_Open(Cancel As Integer)
    
    Report.RecordSource = "SELECT Distinct tblInvoice.InvoiceDate,tblInvoice.InvoiceID AS InvoiceID," _
    & " tblHorseInfo.HorseID, funGetHorse(0,tblHorseInfo.HorseID,false) AS Name, [StableReturnDate] " _
    & " FROM tblInvoice,tblHorseInfo where tblHorseInfo.HorseID " _
    & " = tblInvoice.HorseID" _
    & " and tblInvoice.HorseID=" & Forms!frmActiveFinishedNew![tbHorseID]

结束子

推荐答案

我想过滤HorseID / InvoiceDate，因为每个HorseID / InvoiceDate只会显示一个报告

I want to filter HorseID/InvoiceDate so as only one report per HorseID/InvoiceDate will show

Thansk可以提供任何帮助.... Bob

Thansk for any help....Bob

私人子报告_打开（取消为整数）

    

    Report.RecordSource =" SELECT Distinct tblInvoice.InvoiceDate，tblInvoice.InvoiceID AS InvoiceID，" _
$
    &安培; " tblHorseInfo.HorseID，funGetHorse（0，tblHorseInfo.HorseID，false）AS Name，[StableReturnDate]" _
$
    &安培; " FROM tblInvoice，tblHorseInfo其中tblHorseInfo.HorseID" _
$
    &安培; " = tblInvoice.HorseID" _
$
    &安培; "和tblInvoice.HorseID =" &安培;表格！frmActiveFinishedNew！[tbHorseID]

Private Sub Report_Open(Cancel As Integer)
    
    Report.RecordSource = "SELECT Distinct tblInvoice.InvoiceDate,tblInvoice.InvoiceID AS InvoiceID," _
    & " tblHorseInfo.HorseID, funGetHorse(0,tblHorseInfo.HorseID,false) AS Name, [StableReturnDate] " _
    & " FROM tblInvoice,tblHorseInfo where tblHorseInfo.HorseID " _
    & " = tblInvoice.HorseID" _
    & " and tblInvoice.HorseID=" & Forms!frmActiveFinishedNew![tbHorseID]

结束子

嗨TurnipOrange，

Hi TurnipOrange,

因为您引用了该行：   " = tblInvoice.HorseID" ，确切地说，该文本包含在RecordSource中，而不是其值。

Because you have quoted the line:   " = tblInvoice.HorseID" , exactly that text is included in the RecordSource, instead of its value.

请尝试：

    ;  Report.RecordSource =" SELECT Distinct tblInvoice.InvoiceDate，tblInvoice.InvoiceID AS InvoiceID，" _
$
    &安培; " tblHorseInfo.HorseID，funGetHorse（0，tblHorseInfo.HorseID，false）AS Name，[StableReturnDate]" _
$
    &安培; " FROM tblInvoice，tblHorseInfo" _
$
    &安培; "  WHERE tblHorseInfo.HorseID" &  = tblInvoice.HorseID _
$
    &安培; "  AND tblInvoice.HorseID =" &安培;表格！frmActiveFinishedNew！[tbHorseID]

    Report.RecordSource = "SELECT Distinct tblInvoice.InvoiceDate,tblInvoice.InvoiceID AS InvoiceID," _
    & " tblHorseInfo.HorseID, funGetHorse(0,tblHorseInfo.HorseID,false) AS Name, [StableReturnDate] " _
    & " FROM tblInvoice,tblHorseInfo" _
    & " WHERE tblHorseInfo.HorseID " &  = tblInvoice.HorseID _
    & " AND tblInvoice.HorseID=" & Forms!frmActiveFinishedNew![tbHorseID]

我个人不使用构造：FROM tblInvoice，tblHorseInfo。据我所知，这会产生Carthesian产品，因此必须使用DISTINCT。我更喜欢以下内容：

Personally I do not use the construction: FROM tblInvoice,tblHorseInfo. As far as I remember that results in a Carthesian product, hence the necessaty to use DISTINCT. I prefer something like:

    " FROM（tblInvoice INNER JOIN tblHorseInfo on tblHorseInfo.HorseID = tblInvoice.HorseID）"

    " FROM (tblInvoice INNER JOIN tblHorseInfo ON tblHorseInfo.HorseID = tblInvoice.HorseID)"

Imb。

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