Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    2

    Question Unanswered: Filling a table with patrol based on a set range

    I’ve got a table that has road names and mile posts in it. A second table has a list of patrols with the roads, beginning mile post and ending mile post that they are responsible for. I want to create a third table that will list all the roads in table one with the patrol name that fits between the beginning and ending mile post. Some of the roads in table one will not fall into the criteria in table two so it should list in table three that ‘no patrol’.

    I made a query and only get the roads that fall into the ranges of patrolled roads in table two. Or get multiple entries of the roads in table one; one listing the correct patrol and the remaining listing ‘no patrol’.

    Perhaps there is another way of performing this.

    dlindval

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Private Sub control_AfterUpdate

    comboBox.rowsource = "..."
    comboBox.reQuery

    End Sub
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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