Search results

  1. H

    Report filtered by 2 yes/no fields

    I have played with that all ways, and can not find a way to align tops, yet keep all on the first page
  2. H

    Report filtered by 2 yes/no fields

    Acutally just got it figured out how to do the choices, but still can NOT get my report straightened out!
  3. H

    Report filtered by 2 yes/no fields

    Thank you all for your help. How would i set up a "Marital Status" with the choices? Sorry, I am ignorant!!! Also, I got the report designed, but I am having a glitch I cannot figure out. See attachment. How do i keep the top of the columns lined up, OR how can I force the group to the...
  4. H

    Report filtered by 2 yes/no fields

    Thank you SO MUCH! I really appreciate the help from both of you. The above worked SUPER!! So glad for those of you who are willing to help those of us who don't have all the expertise!! Thanks again!
  5. H

    Report filtered by 2 yes/no fields

    Thank you SO MUCH! I really appreciate the help from both of you. The above worked SUPER!! So glad for those of you who are willing to help those of us who don't have all the expertise!! Thanks again!
  6. H

    Report filtered by 2 yes/no fields

    Thank you very very much. Let me try that in the morning!
  7. H

    Report filtered by 2 yes/no fields

    SELECT [Montezuma Congregation 2022 Individual Record].[Household Last Name], [Montezuma Congregation 2022 Individual Record].[Household First Name], [Montezuma Congregation 2022 Individual Record].[First Name], [Montezuma Congregation 2022 Individual Record].[Last Name], [Montezuma Congregation...
  8. H

    Report filtered by 2 yes/no fields

    Thank you for your help, i pasted that in to a new query SQL, not sure what you mean by WHERE CLAUSE, but in design view, only widow had TRUE. I wanted both Widower and Widow to have TRUE, but when I put TRUE in the WIDOWER, then run the query, it is all blank.. Sorry I am do dumb!!!! Any...
  9. H

    Report filtered by 2 yes/no fields

    The query I am basing my report on is used to convert birthdate to age off of a table. I want to include the age in my report, so i am basing the report on the query insted of the table. Following is the SQL of my query. SELECT [Montezuma Congregation 2022 Individual Record].[Household Last...
  10. H

    Report filtered by 2 yes/no fields

    So I am not good at writing code LOL, but in my report properties, in the "filter", i have the following ([Montezuma Congregation 2022 Individual Record].[Widow] Not In (0)) and that filters the "widows" out, but I also have a "widowers" field and I want my report to include both widows...
  11. H

    Report filtered by 2 yes/no fields

    I do have a report created that filters one of the check boxes and filters it upon opening the report. How do a add the second check box in to that?
  12. H

    Report filtered by 2 yes/no fields

    I am trying to create a report based on a query. I have 2 different yes/no checkbox fields and amy trying to filter my report results based on both of those check box fields being "checked" Please help, i cannot find a way to make that work! My records either have field1 check box checked...
Back
Top Bottom