Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006

    Question Unanswered: Querie and Count the results

    I have two tables: "Vender" and "Jobs". I want a field (named "2006") in my vender-profile form to display the number of times in 2006 that that vender's name appears in the "Vender" field of my Jobs table. I hope to repeat the code for other fields ("2005", "2004" & "2003").

    Any suggestions?


  2. #2
    Join Date
    Sep 2003
    Suggestions on what? You can add a textbox bound to a query that does your count for you ... You could have a combobox that lists the years and upon selection generates the query that the textbox uses and requerys the textbox ...
    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