Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    37

    Unanswered: Query in a form ?

    Is it possible to get a count of the number of reseults returned in a query that is used in a form ?
    The form lets you view each query result in order but I would like this down with a subform stating the total amount ?

    Cant think of how to get it with sql (never used it on a query)

    Any information or ideas ?

    JD

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by JD|
    Is it possible to get a count of the number of reseults returned in a query that is used in a form ?
    The form lets you view each query result in order but I would like this down with a subform stating the total amount ?

    Cant think of how to get it with sql (never used it on a query)

    Any information or ideas ?

    JD
    SELECT COUNT(*) FROM QueryNameHere;
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •