adding records in a query

From: dola (anonymous_at_discussions.microsoft.com)
Date: 04/30/04 

Date: Thu, 29 Apr 2004 17:06:03 -0700

I am hoping to be able to add numbers to the names I have listed in a query. For instance,

1 John Doe
2 Jane Smith
3 Lise Scott

So it counts the total number of people or records returned. i am sure this is possible but I can't get it to work.

THANKS>

DOLA

Relevant Pages

  • counting records in a query
    ... I am hoping to be able to add numbers to the names I have listed in a query. ... John Doe ... Jane Smith ... DOLA ...
    (microsoft.public.access.queries)
  • Re: find duplicates from a range of data
    ... Frank Kabel ... > Service A John Doe ... > Service B Jane Smith ... > Doug K ...
    (microsoft.public.excel.misc)
  • Re: Cumulative cost
    ... Open a new query in design view. ... Add the field that holds "John Doe" and the field that holds the Amount. ... calculate the year to date by student and the program+ Program Cost ... to calculate the students YTD cost basis in a query? ...
    (microsoft.public.access.forms)
  • RE: String concatenation in a HAVING Clause
    ... Look in Books Online regarding wild cards and the LIKE statement. ... example belows. ... The 1st query will not return anything, ... WHERE 'John Doe' LIKE '%John%' ...
    (microsoft.public.sqlserver.programming)
  • Re: two append tables?
    ... Someone yesterday suggested I could run a query ... to put the names into the employee table but Im not sure how. ... John Doe ... SQL mode that would somehow let me make a new table combining the tables by ...
    (microsoft.public.access.externaldata)