RE: count and display YES results from subform to parent form

Hi

A couple of ways but the easist is to put a field in your query Something
like YesCount: Iif(NoShow= True, 1, 0). You can then put in a text box that
gives a total.
=Sum(NoShow)

Neville Turbit
www.projectperfect.com.au

"ghostman via AccessMonster.com" wrote:

i have a field NoShow (YES/NO field) on my subform with 3 records, 2 were
marked YES..

how can count this YES answers and display it on my parent form?

thanks...

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200907/1


.

Relevant Pages

  • Printing query from form
    ... get to the database window to open and/or print a query or query results. ... parent form I've set up a button to save and open the results in an Excel ... The issue is that this opens the query in the background, ... the user closes the preview window, the display goes to the open query. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Problem with SQL and Recordset
    ... This assumes that the name of the subform control on the parent form is the ... NextSuffix field from the "query" to be entered into the Suffix field on ... Dim mySQL As String ...
    (microsoft.public.access.modulesdaovba)
  • Re: DB Result Wizard Error
    ... Also noted that one folder, which contains no information can't be deleted, ... >> For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... >> to display the new equipment information. ... >> is in the table was added to the query. ...
    (microsoft.public.frontpage.programming)
  • RE: Just starting to design a form (or is it a query?)
    ... A Form is used to display the data and allow ... A query can be the record source for a form. ... that match an ID in the Assessment table. ... Now, assuming this is the case, what you need is a form with a sub form. ...
    (microsoft.public.access.gettingstarted)
  • Re: database lookup
    ... the query on the subsequent page, and display the "drill down" data. ... The thing with PHP and MySQL is that you need the user to do an action ... I tried to state that I have the database designed and implemented but I ...
    (alt.php)