Counting records :-(

From: Ady (adrian.symons_at_lineone.net)
Date: 05/30/04 

Date: Sun, 30 May 2004 16:37:10 +0100

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)
  • Re: Counting records :-(
    ... You need to add an OrderID group header section. ... > I have a report that is linked to a query. ...
    (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: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
Quantcast