Re: Counting records :-(

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 05/30/04 

Date: Sun, 30 May 2004 11:01:16 -0500

You need to add an OrderID group header section. Add a text box to the
header:
    Name: txtCountOrders
    Control Source: =1
    Running Sum: Over All
Then add text box to your report footer:
    Control Source: =txtCountOrders 

-- 
Duane Hookom
MS Access MVP
"Ady" <adrian.symons@lineone.net> wrote in message
news:%23sDPGtlREHA.1396@TK2MSFTNGP12.phx.gbl...
> Hi There
>
> I have a report that is linked to a query. In this query I have a field
name
> orderID. This is the order number. If one order has 5 lines (in other
words
> the customer has ordered 5 items) the orderID is listed down the column 5
> times. For example:
>
> QUERY EXAMPLE:
> orderID        Part Number
> W1256        Part A
> W1256        Part B
> W1256        PartC
> W1256        Part D
> W1256        PartE
>
> This is fine and works well....However, in my report I am tring to count
the
> total number of individual orders. I am placing my formula in the "Report
> Footer"
>
> =Count([orderID])
>
> The problem is it is counting all the lines! For instance the example
above
> should show 1, however with my formula it is showing 5. I only need it to
> count the individual numbers!
>
> Any help offered will be most appreciated!
>
> Kind Regards
>
> Ady
>
>
>

Relevant Pages

  • Re: Proper Query Summing
    ... OrderLines has fields like: ... OrderID ... My problem comes with a report I want to run. ... So I set up my query with the Orders, OrderLines, and TypeList tables. ...
    (comp.databases.ms-access)
  • Counting records :-(
    ... I have a report that is linked to a query. ... the customer has ordered 5 items) the orderID is listed down the column 5 ... total number of individual orders. ...
    (microsoft.public.access.reports)
  • RE: How do I eliminate rows where field value count is =>10?
    ... let's assume you want to query the OrderDetails table in the sample ... want to return records with OrderID values with less than 3 similar OrderIDs. ... SELECT UniqueIdentifier ... I am building a report in Access 2003 from a table. ...
    (microsoft.public.access.reports)
  • Re: OrderID or DataTable
    ... It really depends on how your partner is building the report. ... Reporting Services, it makes sense to send him the OrderID as the query is ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Print command prints all reports in database?
    ... In your subform, on the OrderID key field, use it's ... This should open the report, ... DoCmd.Open Report line showed up in red and when I hit the debug it ... problem printing from the print command under the file menu. ...
    (microsoft.public.access.reports)
Quantcast