is it better to query or to filter?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • vircalendar via AccessMonster.com
    #1

    is it better to query or to filter?

    I have a form with two subforms. The subforms get their data from the same
    two tables, with several fields that overlap and several others that do not.
    Is it better to have these subforms get their data from two separate queries
    or to have a single query that is then filtered differently by the two
    subforms?

    --
    Message posted via http://www.accessmonster.com

    Tags: None
    • Tom van Stiphout
      #2
      Re: is it better to query or to filter?

      On Sat, 22 Mar 2008 16:30:28 GMT, "vircalenda r via AccessMonster.c om"
      <u4313@uwewrote :

      Take 5 minutes to try it both ways, and let us know how you fare.
      -Tom.

      >I have a form with two subforms. The subforms get their data from the same
      >two tables, with several fields that overlap and several others that do not.
      >Is it better to have these subforms get their data from two separate queries
      >or to have a single query that is then filtered differently by the two
      >subforms?

        Comment

        • vircalendar via AccessMonster.com
          #3
          Re: is it better to query or to filter?

          I don't really see any difference, but I'm wondering what I might see as the
          files get larger.

          Tom van Stiphout wrote:
          >Take 5 minutes to try it both ways, and let us know how you fare.
          >-Tom.
          >
          >>I have a form with two subforms. The subforms get their data from the same
          >>two tables, with several fields that overlap and several others that do not.
          >>Is it better to have these subforms get their data from two separate queries
          >>or to have a single query that is then filtered differently by the two
          >>subforms?
          --
          Message posted via AccessMonster.c om
          http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200803/1


            Comment

            • vircalendar via AccessMonster.com
              #4
              Re: is it better to query or to filter?

              I don't really see any difference, but I'm wondering what I might see as the
              files get larger.

              Tom van Stiphout wrote:
              >Take 5 minutes to try it both ways, and let us know how you fare.
              >-Tom.
              >
              >>I have a form with two subforms. The subforms get their data from the same
              >>two tables, with several fields that overlap and several others that do not.
              >>Is it better to have these subforms get their data from two separate queries
              >>or to have a single query that is then filtered differently by the two
              >>subforms?
              --
              Message posted via AccessMonster.c om
              http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200803/1


                Comment

                • Tom van Stiphout
                  #5
                  Re: is it better to query or to filter?

                  On Mon, 24 Mar 2008 04:48:10 GMT, "vircalenda r via AccessMonster.c om"
                  <u4313@uwewrote :

                  Sorry, that's what I meant: write a few lines of code that quickly add
                  100,000 rows or whatever is realistic for your scenario, and try
                  again.

                  -Tom.

                  >I don't really see any difference, but I'm wondering what I might see as the
                  >files get larger.
                  >
                  >Tom van Stiphout wrote:
                  >>Take 5 minutes to try it both ways, and let us know how you fare.
                  >>-Tom.
                  >>
                  >>>I have a form with two subforms. The subforms get their data from the same
                  >>>two tables, with several fields that overlap and several others that do not.
                  >>>Is it better to have these subforms get their data from two separate queries
                  >>>or to have a single query that is then filtered differently by the two
                  >>>subforms?

                    Comment

                    Previous template Next
                    Working...